Viewing 15 posts - 25,996 through 26,010 (of 49,552 total)
jasonshaw (5/23/2011)
I am assuming that this serializing access to this table is handled by Sql Server internally.
No, it's handled by you, in code.
If your code assumes there's only...
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 23, 2011 at 2:52 am
jasonshaw (5/23/2011)
Going back to the original plan, what exactly causes the bottleneck.
The fact that you have to serialise access to that table (one connection at a time) to avoid...
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 23, 2011 at 2:18 am
mike-1098131 (5/23/2011)
What I find supprising is that there is no way in 2008R2 to 'Save As' type of means to create the backup for a previous version of MSSQL.
Do you...
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 23, 2011 at 2:14 am
???
No detail, no attachment. What's 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
May 23, 2011 at 1:56 am
There is no way to restore a higher version DB to a lower version of SQL. This is true no matter what versions you're dealing with.
The database file structures may...
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 23, 2011 at 1:55 am
Now this is funny...
http://blog.jitbit.com/2011/05/what-if-drivers-were-hired-like.html
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 23, 2011 at 12:08 am
http://www.google.com/search?q=computed+persisted+column
In most cases a computed column can be indexed without needing to persist 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
May 22, 2011 at 11:49 pm
No you can't. If the query is frequently run, it won't be aged out, but there are things that will invalidate plans, there are things that will clear the entire...
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 22, 2011 at 11:36 pm
Jeff Moden (5/22/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 22, 2011 at 11:33 pm
shiv-356842 (5/22/2011)
But some body says we will truncate the table in primary database automatically it will truncate in secondary database is it True ?
Automatically, no.
Log shipping works by transferring all...
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 22, 2011 at 11:31 pm
ALZDBA (5/22/2011)
I've seen the same behaviour.You'll have to alter the dblevel yourself if desired (even for system db)
Not compat level. He said the DB engine wasn't available for install.
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 22, 2011 at 2:23 pm
Bear in mind that practice exams (MeasureUp, Transcend, etc) are not written by MS. They're written by independent companies based on the MS provided list of what's covered by 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 22, 2011 at 2:23 pm
It's certainly possible, just means someone ran a TRUNCATE TABLE or DROP TABLE (depending whether the table is there and empty or not) on the primary server.
Fixing this kind of...
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 22, 2011 at 9:52 am
Repeating yourself is not adding clarity.
Where is what stored? The definition? It's part of the procedure definition, so in the system tables. There's no separate storage, no more than a...
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 22, 2011 at 9:23 am
You can wait, or you can restart and wait. There is no way to cancel or stop a rollback (if you could, it would result in the DB going suspect...
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 21, 2011 at 6:40 am
Viewing 15 posts - 25,996 through 26,010 (of 49,552 total)