Viewing 15 posts - 28,516 through 28,530 (of 49,552 total)
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1046305-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
January 12, 2011 at 1:33 am
Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
There's nothing in general wrong with correlated subqueries.
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
January 11, 2011 at 11:41 pm
You can't. SQL only allows for full, filegroup or file-based restores, not object-level restores. For object restores you need a 3rd party tool, like the ones mentioned above.
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
January 11, 2011 at 11:38 pm
SQL manages memory for queries itself. What are you trying to do here that you want memory allocated?
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
January 11, 2011 at 11:37 pm
On 2005 you're pretty much limited to a SQL Trace (server-side trace) or triggers. Triggers if you only want to capture data changes, trace if you want the exact script...
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
January 11, 2011 at 11:20 pm
There's no such thing as a non-logged operation in SQL Server. All data modifications are logged.
In bulk logged and simple recovery, index rebuilds are minimally logged, index reorganise is still...
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
January 11, 2011 at 11:00 pm
MothInTheMachine (1/11/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
January 11, 2011 at 10:58 pm
I would hate to see how big the tran log reaches with an entire month's transactions in it.
Seriously, once a month is a really bad idea. The log will be...
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
January 11, 2011 at 10:46 pm
It doesn't. No use or benefit whatsoever.
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
January 11, 2011 at 10:41 pm
AndrewSQLDBA (1/11/2011)
Sorry, that did not work.
Can you be a bit more specific? Did it throw an error and if so what error? Something else?
Can you post the backup command 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
January 11, 2011 at 1:50 pm
Please note: 3 year old post.
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
January 11, 2011 at 1:42 pm
I suppose it depends on what we call a developer. If we take that as application (front-end) developer, then there really isn't much of real interest. Database developer - whole...
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
January 11, 2011 at 8:11 am
Grant Fritchey (1/11/2011)
From the developer point of view? Honestly, not much.
Spatial data, filtered indexes, new date and time datatypes, merge, filestream, sparse columns etc are 'not much'? Thinking of R2...
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
January 11, 2011 at 7:32 am
I suspect that before anyone can answer that question you're going to have to say where your company is based. The applicable laws in the country I live in are...
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
January 11, 2011 at 6:56 am
Don't reinvent the wheel. There are lots of well written, well tested index maintenance scripts available, like the one Ninja recommended.
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
January 11, 2011 at 6:54 am
Viewing 15 posts - 28,516 through 28,530 (of 49,552 total)