Viewing 15 posts - 16 through 30 (of 90 total)
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
July 22, 2015 at 2:17 pm
I also read on an MS web site that the default cursor for SQL Server 2008 is set as GLOBAL.
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
February 3, 2015 at 9:31 am
Thanx! Your article and links provider by responders has prompted me to do more research (which I should have already done!).
Good Job!
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
February 3, 2015 at 7:11 am
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
February 3, 2015 at 6:26 am
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
...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
January 14, 2015 at 8:26 am
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
June 5, 2014 at 12:26 pm
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....
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
June 5, 2014 at 11:10 am
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,...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
June 5, 2014 at 10:55 am
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
June 5, 2014 at 8:50 am
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
June 5, 2014 at 6:35 am
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
June 2, 2014 at 2:56 pm
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 15, 2014 at 1:44 pm
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....
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 15, 2014 at 11:30 am
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 15, 2014 at 11:06 am
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
March 25, 2014 at 9:58 am
Viewing 15 posts - 16 through 30 (of 90 total)