I know this is old, but I needed a refresher and came across this. I've found it's better not to do the query in the sendmail. Export the...

I also read on an MS web site that the default cursor for SQL Server 2008 is set as GLOBAL.

Thanx! Your article and links provider by responders has prompted me to do more research (which I should have already done!).

Good Job!

Great and timely article. Using your search query I discovered we have 129 procs using cursors. However, I was hoping you would show code examples of the Local...

Is EXCEPT better, or worse, than using:

Select t1.col1, t1.col2, t1.col3

from table1 t1

where t1.col1 not in (select t2.col1 from table2 t2

...

using a search I found a "Documents" folder under USERS, but there is no Documents folder under any Windows profile in the USERS folder. Windows 7 won't let me...

After I posted I found the program was installed on my PC. I went to start/programs and there it was. If I knew it was there I'd forgotten....

Naaa. No "documents" folder. Do have "My Documents". I will build BOTH folders and proceed as you suggested. I didn't intentionally change anything about the PC setup,...

I know I'm late for the party and dumb as a piece of plastic, but there is no "documents" or "windowspowershell" anywhere under my profile. when I type $profile in...

following the logic that "the only dumb question is the one which doesn't get asked"-- how do you start Powershell? from SSMS, cmd prompt?

Hey, you said...

I look forward to articles like this displaying the new technology. We're on SS 2008 and have no plans to change any time soon. So I don't have...

My expertise level in SQL is somewhere below the "DBA in diapers" (I couldn't think of a cool phrase to express my ineptness), but if the clustered servers all share...

Don't want to get off topic, but we have our SQL running on a VM and would like to have another running SQL ready to go in case of emergency....

Since I didn't know what "clustering" was (other than an inference in a Clint Eastwood movie) it was an interesting learning event for me. I need a disaster recovery...

I'm going to try to adjust my timing on the jobs. the full backup restore takes 34 mins. the logs take a few seconds. I should be able to fit...