Viewing 15 posts - 76 through 90 (of 286 total)
Thanks Lowel !
But my problem is that the data is integer and I get it as 465, 356, etc .. I need to convert it into meaning full data.
I guess...
December 16, 2011 at 2:18 pm
Pedro Lopes MS (12/15/2011)
You know, this code was submitted over 4 years ago. SQLServerCentral just published it again. 🙂
I'll correct this one and others I've submitted a...
December 15, 2011 at 4:20 pm
Pedro Lopes MS (10/21/2007)
Comments posted to this topic are about the item <A HREF="/scripts/61297/">Check Instance Info</A>
Very nice piece of code.
This will not report correct IP value on 2008R2 .. You...
December 15, 2011 at 1:35 pm
gonzamole (10/10/2011)
Comments posted to this topic are about the item <A HREF="/scripts/Maintenance/75981/">Next grow for all databases per disk</A>
gives insorrect syntax near 'Data' END, ' 🙂
October 12, 2011 at 3:47 pm
joffwilliams (9/21/2011)
September 21, 2011 at 7:38 pm
S.K. (5/2/2011)
Comments posted to this topic are about the item <A HREF="/articles/Administration/72733/">SQL 2008 SP/CU Patching Through Windows Scheduled Tasks</A>
Great post ... only one question .. how can I pass instance...
May 3, 2011 at 11:45 am
jwalker8680 (4/6/2011)
Comments posted to this topic are about the item <A HREF="/scripts/sp_who2/72823/">Capture and Alert for Blocked SPIDS with SP_WHO2</A>
Very good effort and nice script !
Just to add my 2 cents,
It...
April 6, 2011 at 11:52 am
jwalker8680 (4/6/2011)
Comments posted to this topic are about the item <A HREF="/scripts/sp_who2/72823/">Capture and Alert for Blocked SPIDS with SP_WHO2</A>
Very good effort and nice script !
Just to add my 2 cents,
It...
April 6, 2011 at 11:52 am
annasql (4/1/2011)
April 1, 2011 at 1:23 pm
phaniverma.dba (4/1/2011)
How to find whether SQL server needs to reinstalled or not if the drive goes corrupt.
Check the windows event logs as well as sql server error logs.
BTW, what made...
April 1, 2011 at 1:21 pm
annasql (4/1/2011)
Is there a way to find out if a database is no longer used for some period of time?Thanks
Run profiler for 3 to 4 business days. Make sure u...
April 1, 2011 at 12:17 pm
annasql (4/1/2011)
Is there a way to find out if a database is no longer used for some period of time?Thanks
Run profiler for 3 to 4 business days. Make sure u...
April 1, 2011 at 12:17 pm
GSquared (3/9/2011)
Change:
WHILE @@rowcount > 0
with Letters(Letter)
...
March 9, 2011 at 2:53 pm
GSquared (3/9/2011)
Change:
WHILE @@rowcount > 0
with Letters(Letter)
...
March 9, 2011 at 2:52 pm
Steve Jones - SSC Editor (3/9/2011)
Do you mean any row with a repeating letter? What about "letter" itself? It's a valid repetition.
Thanks Steve for asking, I have it on http://www.sqlservercentral.com/Forums/Topic1075800-146-1.aspx
somehow...
March 9, 2011 at 2:46 pm
Viewing 15 posts - 76 through 90 (of 286 total)