Server Configuration

SQL SERVER 2005 Full backup job takes 3 times longer than before
Hi guys, I have a sql server 2005 production db server. Before the full backup job using maintenance plan is only taking around 16 minutes but recently it's taking around an hour. I'm not sure what's causing the problem. The databases just get a little bigger so it shouldn't be the problem. The only thing I can ... 2 Apr 2010 12:38

SQL Server 2008 Extended Events
I am using SQL Server 2008 Std SP1 on a Windows 2008 std 64-bit server. I am trying to understand and use Extended Events. I have created a session that is to monitor tempdb usage when ever there is a physical page write. I want to capture the query that is causing this action. Below is my session defintion... 1 Apr 2010 11:17

SQL Server 2000+2008 on Win2008x64 question
Hi, I have SQL Server 2000 on my Win2008x64 server, the db file is on the D drive, while the program file is on C drive. Today I installed the SQL Server 2008 on the same machine. After the installation, the SQL Server Service Manager is still the same as just only SQL Server 2000 installed, I'm thinking isn't... 1 Apr 2010 06:50

Alter table Add column to merge publication
We are currently on SQL Server 2008 and I would like to add a column to a table that exists in our merge replication. Below is what I ran in our test environment Alter Table TableName Add ColumnNameTypeID uniqueidentifier Null The column was added, but the Default value or Binding was set to NewID() and th... 31 Mar 2010 17:44

Log Shipping not restoring transaction log backup
Buenos dias! estoy intentando configurar un log shipping desde un sql 2005 (primario) a un sql 2008 (secundario). Se configura todo bien, los jobs se crean perfectamente, los agentes usan una cuenta del Hi! i'm trying to setup log shipping between a sql server 2005 (primary) and a sql server 2008 (secondary).... 31 Mar 2010 09:53

Min Value Function
I have a function which returns the minimum value CREATE FUNCTION Getname2 (@Int1 FLOAT(8), @package1 VARCHAR(50), @Int2 FLOAT(8), @package2 VARCHAR(50), @Int3 FLOAT(8), @package3 VARCHAR(50) ... 31 Mar 2010 09:53

File-Permissions in DATA-Folder (Attach / Detach)
Hi, after having some issues with File-Permissions during attach attempts, I played around a bit and found something weird which I'd like someone to confirm: Scenario: - Windows 7 Ultimate 64 bit - SQL Server 2008 Developer Edition (Version 10.0.2531.0) - Database for testing: "Test" - SSMS running under ... 31 Mar 2010 17:44

Subtract Month
Hi I want to update a column of data type datetime in SQL Server 2000. Let Col1 23/11/2009 31/12/2009 01/01/2010 i want to substract the 1 from month. i.e. col1 shoul look like this 23/10/2009 31/11/2009 01/12/2009 Regard, Muhammad Bilal ... 31 Mar 2010 08:45

JDBC Driver issue with SQL Server 2008
Hi, I just migrated to SQLServer 2008 Express from the 2005 version. I have a Java application that uses SQL JDBC Driver (sqljdbc4.jar - latest version) to connect to DB. I had to upgrade to the latest driver as the previous version sqljdbc.jar did not work with SQL 2008. Now my application works, but in one ins... 31 Mar 2010 16:37

Problem with formatting numbers
Hello, I have a problem with an Italian web site written in asp language. While it was running on SQL Server 2005 on Windows 2003 Server Italian version, it was ok. Now I moved on a English Windows 2003 machine and it does not work anymore. The float numbers are not correctly written in the database. For e... 31 Mar 2010 13:16