SQLQuest29

Forum Replies Created

Viewing 15 posts - 76 through 90 (of 286 total)

RE: Convert an interger to year month and days

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...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

December 16, 2011 at 2:18 pm

#1422728
RE: Check Instance Info

Pedro Lopes MS (12/15/2011)
Thanks for that.
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...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

December 15, 2011 at 4:20 pm

#1422257
RE: Check Instance Info

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...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

December 15, 2011 at 1:35 pm

#1422210
RE: Next grow for all databases per disk

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, ' 🙂
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

October 12, 2011 at 3:47 pm

#1393722
RE: Running SQL server 2008R2 on Hyper-V crashed sql server.

joffwilliams (9/21/2011)
We run a few SQL 2008R2 instances on Server 2008 R2 VMs in Hyper-V. It's not ideal to use dynamic memory presently (Denali promises better support), but if you...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

September 21, 2011 at 7:38 pm

#1384911
RE: SQL 2008 SP/CU Patching Through Windows Scheduled Tasks

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...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

May 3, 2011 at 11:45 am

#1319269
RE: Capture and Alert for Blocked SPIDS with SP_WHO2

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...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

April 6, 2011 at 11:52 am

#1308180
RE: Capture and Alert for Blocked SPIDS with SP_WHO2

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...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

April 6, 2011 at 11:52 am

#1308179
RE: Login and its permissions

annasql (4/1/2011)
Is there a way or a query that I can find a login that has waht access levels and permissions on all objects on a sql server...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

April 1, 2011 at 1:23 pm

#1306666
RE: Drive corrupt & sql reinstallation.

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...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

April 1, 2011 at 1:21 pm

#1306665
RE: if a database in use

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...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

April 1, 2011 at 12:17 pm

#1306645
RE: if a database in use

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...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

April 1, 2011 at 12:17 pm

#1306644
RE: String search and replace it with single letter

GSquared (3/9/2011)
Since you already have the letters (in your Numbers table), you don't need the CTE at all.
Change:
WHILE @@rowcount > 0
with Letters(Letter)
...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 9, 2011 at 2:53 pm

#1296816
RE: String search and replace it with single letter

GSquared (3/9/2011)
Since you already have the letters (in your Numbers table), you don't need the CTE at all.
Change:
WHILE @@rowcount > 0
with Letters(Letter)
...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 9, 2011 at 2:52 pm

#1296815
RE: String search and replace it with single letter

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...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 9, 2011 at 2:46 pm

#1296813

Viewing 15 posts - 76 through 90 (of 286 total)