Viewing 15 posts - 26,731 through 26,745 (of 49,552 total)
Michael Valentine Jones (4/13/2011)
Does this topic have a purpose?
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
April 13, 2011 at 2:05 pm
maheshsoft1987 75072 (4/13/2011)
can u give me overview of the exam? if possible
Nothing can be said on the exam without violating NDA.
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
April 13, 2011 at 2:01 pm
Grant Fritchey (4/13/2011)
, off to the test environment.
*Totally irrelevant thought*
.. to the TestMobile Batman!
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
April 13, 2011 at 1:06 pm
Dan.Humphries (4/13/2011)
Now Politicians from IL they scare the crap out of me. Will Blago ever go away?
Swap yours for mine? http://www.news24.com/SouthAfrica/Politics/The-revolution-is-on-trial-Malema-20110412
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
April 13, 2011 at 9:58 am
Never test on the production server. Ever.
That's what dev/test environments are for.
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
April 13, 2011 at 9:50 am
Let's turn the question around. Why do you want to use it?
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
April 13, 2011 at 9:50 am
As a client machine either will work. If you're processing massive databases on your desktop, then 64-bit may be of use, but for normal applications (including SQL management tools), 32...
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
April 13, 2011 at 9:48 am
CirquedeSQLeil (4/13/2011)
Leave the contract early without notice and prior to completing the stated work.
What does his contract require? Solo or contracting house?
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
April 13, 2011 at 9:45 am
CirquedeSQLeil (4/13/2011)
How many of you would walk out on a job without completing it (as a contractor/consultant) - if you were getting paid?
Never (short of illegal practices by the company)
Even...
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
April 13, 2011 at 9:45 am
The checkpoint is database-specific, the drop clean buffers drops every single clean page from the entire data cache.
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
April 13, 2011 at 9:43 am
The collation is on the column. The index can't have a different collation to the column that it's an index 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
April 13, 2011 at 9:40 am
There's no silver bullet when if comes to performance tuning (I wish there was, i have a client in need of one...).
1) Find badly performing procedures
2) Fix badly performing...
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
April 13, 2011 at 6:06 am
Is he a member of db_datareader? A member of db_owner? a member of sysadmin?
Granting view definition doesn't remove permissions, it adds permissions
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
April 13, 2011 at 5:58 am
You can't restore pages then, that was an option when they were corrupt, not now.
Because of the log restore (and because checkDB is logged), if you restore pages now...
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
April 13, 2011 at 4:25 am
I still don't understand what you're asking.
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
April 13, 2011 at 3:59 am
Viewing 15 posts - 26,731 through 26,745 (of 49,552 total)