Viewing 15 posts - 25,726 through 25,740 (of 49,552 total)
sqlzealot-81 (6/6/2011)
To specify...Quotes from "Paul"
May I suggest you cut that quote down to just the portion needed and reference 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
June 6, 2011 at 2:10 am
An in-place update.
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
June 6, 2011 at 2:05 am
Jason L (6/6/2011)
rebuilding the a clustered index will also rebuild any non-clustered indexes on that table.
It does not.
Rebuilding the clustered index rebuilds just the clustered index. To rebuild all indexes...
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
June 6, 2011 at 1:56 am
muthukkumaran Kaliyamoorthy (6/6/2011)
sqlzealot-81 (6/6/2011)
Hi, Thought of going back to basics, Whats an update. Is it an operation of delete and insert?
Yep, True the update will delete the value first and...
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
June 6, 2011 at 1:55 am
Gangadhara MS (6/5/2011)
DECLARE @table TABLE (number nvarchar(max))
Why on earth are you using an NVarchar(max)? Expecting numbers with 2 billion unicode digits somehow?
But its not returning with proper result.
With that...
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
June 5, 2011 at 11:51 pm
http://www.google.com/search?q=SQL+Server+partition+functions
There's also a lot of material in Books Online. If you're studying, that should be the first place you look for anything you're not familiar with.
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
June 5, 2011 at 11:49 pm
drew.allen (6/3/2011)
This is something that is best left to the presentation layer.
Completely agree. This is something that should be done in the client app, not in the database.
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
June 5, 2011 at 11:48 pm
Means it wants 6GB and it has 6GB.
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
June 5, 2011 at 5:24 am
Lynn Pettis (6/4/2011)
I am going to be grandfather![/i]
Looks like I'll need...
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
June 5, 2011 at 4:18 am
Everything can be done without SSMS.
SQLExpress (and all other editions) install a command line tool, SQLCMD. Just about anything that can be done with SSMS can be done with SQLCMD,...
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
June 5, 2011 at 4:16 am
chinn (6/4/2011)
But my question is .If somebody comes to me and asks how much memory SQL Server is actually using out of the allocated how would i answer that...
JeremyE (6/3/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
June 5, 2011 at 4:12 am
Jim Murphy (6/4/2011)
Simple stuff like hacking a database in because the Jr. DBA detached a Suspect database which has corruption
Restore from backup. Depending on your downtime SLA and how...
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
June 5, 2011 at 4:09 am
Jim Murphy (6/4/2011)
Why is it hard to find sessions about corruption and repair?
A) sessions not attended well because no one really cares (percieved as largely irrelevant).
B) community...
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
June 4, 2011 at 4:00 pm
Please note: 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
June 4, 2011 at 3:46 pm
Is that hourly log backup part of the log shipping setup, or a separate log backup job that you're running?
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
June 4, 2011 at 3:44 pm
Viewing 15 posts - 25,726 through 25,740 (of 49,552 total)