Viewing 15 posts - 37,021 through 37,035 (of 49,552 total)
Look up SUM and GROUP BY in the SQL Books Online (SQL Help file, press F1 in management studio to open)
If you can't get it right, post what you 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
August 15, 2009 at 2:56 pm
Jeffrey Williams (8/15/2009)
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
August 15, 2009 at 2:13 pm
Ian Scarlett (8/15/2009)
Mighty talented if it is... all those skills in addition to SQL Server.
Heh. If I wasn't too fussed about the definition of 'expertise' , I could list Pascal,...
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
August 15, 2009 at 1:55 pm
Lynn Pettis (8/15/2009)
You'd think someone with the alphabet soup following his name would know better.
Yes, you would.... Especially the one that reads 'MCT'
I've corrected him elsewhere also today. I'm just...
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
August 15, 2009 at 12:11 pm
Jeff Moden (8/15/2009)
Yeah... I love people's blogs... 😛
Ok, now I'm worried....
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
August 15, 2009 at 11:59 am
Steve Jones - Editor (8/15/2009)
I sometimes think people are trying hard to build a reputation by answering, and don't want to read. They want to just throw something out there.
Throw...
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
August 15, 2009 at 10:41 am
In SQL 2000 passwords were only case sensitive if the server's collation was case sensitive. This means that SQL installed with the default collation on a server with US English...
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
August 15, 2009 at 10:15 am
Why don't people read questions before answering?
Question: How do I recover data that was lost? I have no backups.
Answer: Restore your full backup to another system... etc...
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
August 15, 2009 at 9:19 am
Sarab (8/15/2009)
For this you should have:1. Full Backup prior to this incident.
Considering that he said he has no backup, it's not overly likely that he'll be able to do any...
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
August 15, 2009 at 9:15 am
The code is, apparently, missing
If you're entering html, use the IFCode shortcuts (on the left) and surround it with the XML code tag.
Please post just the fragment of code that's...
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
August 15, 2009 at 2:23 am
Alvin Ramard (8/14/2009)
Gail, be sure to turn your modem off first. You don't want to violate any regulation regarding the use of electronic devices while flying.
No worries. Its power...
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
August 15, 2009 at 2:14 am
In a clustered installation, all databases must be on shared storage and those drives must be set as dependencies of the SQL Service (ie cluster resources themselves).
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
August 14, 2009 at 2:44 pm
Jack Corbett (8/14/2009)
C'mon Gail, you could have left your username and password in there. I might need internet access if I ever get to South Africa!:-P
You'd need to steal...
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
August 14, 2009 at 1:45 pm
That's not updating statistics, that's setting the database-level option 'auto-update statistics' to true or false.
If that's what you were looking for then I apologise, I misunderstood the question.
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
August 14, 2009 at 1:37 pm
Jeff Moden (8/14/2009)
Heh... ask them for a 2 day service rebate and a "finders fee" and see how far you get?
*Falls over laughing*
Yeah that's likely to happen. Not!
BTW... how did...
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
August 14, 2009 at 1:35 pm
Viewing 15 posts - 37,021 through 37,035 (of 49,552 total)