Viewing 15 posts - 28,726 through 28,740 (of 49,552 total)
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1040541-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 1:24 pm
varunkum (12/29/2010)
(
ACCOUNT NUMBER(12) ...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 11:26 am
Some backup please? I don't know how to say what I've already said 3 times again.
http://www.sqlservercentral.com/Forums/Topic1039883-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 11:11 am
What do you want from me? A stamp of approval? A guarantee that your plans are optimal?
I can't give you either. As I said before, it depends. The 100 databases...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 10:59 am
First find out who the connection belongs to and what it's doing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 10:13 am
You can do it with a login trigger if you're on SP2 or above. There's at least one SSC article on login triggers, so try a search (I don't have...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 10:09 am
ankur_libra (12/29/2010)
But Gail you have written your response as 'No'. Request to please calirfy it further.
What clarification do you want? You asked if there's any problems with having a sysadmin...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 9:33 am
No, you'll need to start SQL in it's minimal config mode, then run the ALTER DATABASE to change the tempDB location
Start SQL from the command line with the following (I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 9:23 am
ankur_libra (12/29/2010)
So, kindly tell is there any problem especially in Disaster Recovery scenarios, if SA user password is not available to us and we are unable to use 'SA' user?
No....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 9:10 am
hallidayd (12/29/2010)
Not in 2005. Since your code is 2008 I assume things changed....
The apply failed on 2005, the exists worked just fine (2005 SP3). Changes to the optimiser I would...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 8:28 am
It depends.
Seriously, there's no absolute number that I can pull out that's correct. Depends on the usage of the databases, depends on the way they're accessed, depends on the other...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 8:14 am
WayneS (12/29/2010)
(And I see you answered this yesterday also... thanks again! (Note to self - read (don't skim) the whole thread!))
And a couple weeks ago, and last month. Got to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 8:07 am
TheSQLGuru (12/29/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 8:05 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 7:56 am
Yes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2010 at 7:49 am
Viewing 15 posts - 28,726 through 28,740 (of 49,552 total)