Viewing 15 posts - 5,701 through 5,715 (of 7,168 total)
rockstar283 (7/1/2011)
I am currently workin as a TEMP in my company..and only permanent guys can execute a proc 🙁
Bummer. The article is still relevant. Please see the section titled "Recompile"....
July 2, 2011 at 6:14 am
Welcome maddoxd. You can change the data type of the BirthDate column without dropping and recreating the table, or even bothering with the Primary Key on EmpID. Something like this...
July 1, 2011 at 4:30 pm
I am interested to know the disk subsystem differences too.
Also, with MAXDOP now set to 0 what do your wait stats look like? And what was MAXDOP on the old...
July 1, 2011 at 3:01 pm
jcrawf02 (7/1/2011)
GilaMonster (7/1/2011)
Thanks everyone. Wasn't actually planning on announcing it here.Thankful that you received it, but we didn't need anyone else's validation of your impact. 🙂
Ditto. Like there was any...
July 1, 2011 at 2:24 pm
shanila_minnu (6/30/2011)
How to find out the number of instances installed in a sql server 2000
Just to clarify, number of instances installed in a sql server 2000 is kind of misleading....
July 1, 2011 at 2:14 pm
You're talking about a "catch-all query". Please have a look at this article[/url] by Gail Shaw. It is the article for reference on the topic and will get you where...
July 1, 2011 at 2:07 pm
sturner (7/1/2011)
...But I digress...
Wow, now there's an understatement :hehe:
July 1, 2011 at 2:01 pm
The place where I am working now offers sabbaticals after you have been with the company for 5 years. My team has 32 people, and already 3 people have taken...
July 1, 2011 at 1:50 pm
...checking on something
EDIT:
OK, had to make sure:
Restarting SQL makes the index disappear from the usage stats view altogether. It's not until the index is used again (in some way) that...
July 1, 2011 at 12:29 pm
Just for the record, I prefer PowerShell for this kind of work. It can do all the file system and T-SQL stuff with ease all within the same programming domain.
July 1, 2011 at 12:18 pm
Wildcat (7/1/2011)
Tara-1044200 (7/1/2011)
July 1, 2011 at 12:13 pm
kramaswamy (7/1/2011)
July 1, 2011 at 12:10 pm
kramaswamy (7/1/2011)
GSquared (7/1/2011)
July 1, 2011 at 11:56 am
Copy is a Windows CmdShell command. Try using the Copy-Item PowerShell CmdLet and set the -ErrorAction set to Stop
Copy-Item -Path \\V240\folder\foo.txt -Destination \\V240\folder\bar.txt -ErrorAction Stop
July 1, 2011 at 11:35 am
Service Broker can assist you with getting asynchronous behavior.
July 1, 2011 at 11:18 am
Viewing 15 posts - 5,701 through 5,715 (of 7,168 total)