CTE's are not replacements for temp tables or table variables. A CTE will be incorporated into the actual query...

As a one-time process where there is identified fragmentation issues on the drive - I would take the services offline, perform the defrag and bring everything back up.

As a scheduled...

This error indicates an issue with the network while backing up:

995(The I/O operation has been aborted because of either a thread exit or an application request.).

You see this error...

I use CTE's to organize my queries and move derived tables up to the top of the query. In other cases, I will use a CTE to include row_number,...

Check the ANSI_PADDING settings on the database, the column in question and the connection between the 2 different systems.

I am betting you will find a difference between the 2 which...

Update Statistics has an options to update only column based statistics, index based statistics or both. Please refer to BOL for exact syntax.

Note: sp_updatestats will only update statistics that...

GilaMonster (7/8/2012)

---

It got fixed in SQL 2005, in 2005 SP1, in 2005 SP2, in 2005 SP3 and in 2005 SP4. Basically most of the issues were fixed for SQL2005 RTM,...

I keep hearing that they have fixed this issue - and still...

I started my career as a computer operator for the Army. Left the Army and went to work as a computer operator and realized I wanted to move into...

GSquared (7/5/2012)

---

Whenever I have to modify data in production, I start with "begin transaction" and end with "rollback", run the script, use OUTPUT to check the results, and, when I'm...

AAKR (7/5/2012)

---

Thank you all of you guys.

* copy files from server to server it takes more time...

I heard an option with using of Sanpshot replication we can create the database.

any...

Be aware that the option to purge data after a set time in the agent properties is a one-time manual process.

That is, if you uncheck the option to manage the...

The question I have is how are you going to use this? If you are using this in a where clause it is most likely a better option to...

Is the requirement to remove the UDF something that is mandated by company policy? Or, are you looking at the function as...

How are you checking the database size?

If you are right-clicking the database and selecting properties to see the database size, that size includes the size of the transaction log and...