Viewing 15 posts - 26,401 through 26,415 (of 49,552 total)
Ninja's_RGR'us (5/2/2011)
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
May 2, 2011 at 9:48 am
You need to rebuild the clustered indexes onto the new filegroup.
CREATE INDEX ... WITH DROP_EXISTING specifying ON [NewFileGroup] should work. I seem to recall it works even if the index...
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
May 2, 2011 at 9:47 am
Use profiler.
p.s. 2 year old thread
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
May 2, 2011 at 9:16 am
Ninja's_RGR'us (5/2/2011)
Complaints : Round 2 with Steve
I'm only reporting if he crosses the line to insulting. Like this morning, when he called Craig "mentally retarted"
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
May 2, 2011 at 8:58 am
Ninja's_RGR'us (5/2/2011)
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
May 2, 2011 at 8:40 am
Nope, triggers won't catch a truncate.
Don't grant the permissions. Truncate requires DDL_Admin or table ownership. Don't grant those permissions to people who don't need them.
p.s. 4 year old thread.
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
May 2, 2011 at 8:04 am
My problem is that he doesn't accept corrections, but will argue (often just repeating himself) forever.
He'll learn or leave, not the first one we've had.
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
May 2, 2011 at 7:59 am
forsqlserver (5/2/2011)
Thanks...It means we cannot setup the Differential backup in logshipping or mirroring...??:-)
No it doesn't.
http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/
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
May 2, 2011 at 7:08 am
azhar.iqbal499 (5/2/2011)
Please suggest values for MaxDOP and Cost Threshold for Parallaism,lock and query wait time.
Leave MAXDop. Consider increasing the value of Cost threshold slightly, see if it alleviates the...
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
May 2, 2011 at 7:03 am
SwayneBell (5/2/2011)
Is a "brain-dump" when someone writes the exam then tries to remember and write down the questions?
That or other methods of obtaining and posting the actual questions from the...
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
May 2, 2011 at 7:01 am
Syed Jahanzaib Bin hassan (5/2/2011)
Read Books and CBT nuggets and training videos and all stuff are available on the internet free of cost
CBT Nuggets are most certainly not free, though...
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
May 2, 2011 at 3:29 am
Syed Jahanzaib Bin hassan (5/2/2011)
I'm probably one of the larger SSIS advocates here
I am shocked because you dont know about how to generate T-SQL script from SSIS for the maintenance
Where...
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
May 2, 2011 at 3:26 am
Welsh Corgi (5/1/2011)
Gail went out of his way to assist you.
Just by the way...
Gail != he. http://www.simple-talk.com/opinion/geek-of-the-week/gail-shaw-geek-of-the-week/
Zayidka did say "I’m not asking you to answer these questions for me", hence...
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
May 2, 2011 at 3:20 am
Those are miles off anything that you've posted earlier.
Which are you stuck on, and what have you done so far for the requirements that you're stuck on?
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
May 1, 2011 at 5:07 pm
Craig Farrell (5/1/2011)
Badly, badly phrased. I meant drilled into it further regarding memory swaps and the like. I have a feeling he's ending up in the swapfile some.
Maybe,...
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
May 1, 2011 at 4:16 pm
Viewing 15 posts - 26,401 through 26,415 (of 49,552 total)