Viewing 15 posts - 41,821 through 41,835 (of 49,552 total)
Typically, you don't. The transaction log is not there for data recovery and there's no built-in way (except for ROLLBACK TRANSACTION) to use the transaction log to undo a transaction.
Additionally,...
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 10, 2009 at 12:55 pm
Lynn Pettis (1/10/2009)
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 10, 2009 at 12:39 pm
What I wear on a particular day depends on what I'm doing. I personally detest skirts and I haven't worn one since highschool (where it was required uniform) and 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
January 10, 2009 at 12:38 pm
Jeff Moden (1/10/2009)
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 10, 2009 at 12:23 pm
Lynn Pettis (1/10/2009)
Sorry, I was watching the last 2 episodes of StarGate Atlantis (had them on DVR).
Any good?
Or it could be a result of the Raid 5 configuration of 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
January 10, 2009 at 1:51 am
Gautam Saha (1/9/2009)
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 10, 2009 at 1:48 am
It's parallelism. It's something that SQL decides to do, not the developer.
Not all of the threads will likely be running and there can be more than the maxdop set or...
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 10, 2009 at 1:02 am
If all the queries that filter on the quid are equalities (hence finding 1 row), I'd put a nonclustered index on the Guid and find somewhere else for the cluster.
I've...
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 10, 2009 at 12:48 am
Digs (1/9/2009)
SO are you saying the code in asp.net codebehind and TSQL 2005 stored proceedures can be hacked ...?????
Anyone that has login rights to the SQL Server and either execute...
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 10, 2009 at 12:45 am
No way to tell.
I'm asking what appears to cause it, not the root cause. What are you generally doing when it happens?
Earlier advice still applies. The best people to contact...
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 10, 2009 at 12:35 am
Gautam Saha (1/9/2009)
Can I break up the database so that it consists of 4 mdf/ndf files
You can. What are you trying to achieve by doing so?
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 9, 2009 at 2:54 pm
Tim Riley (1/9/2009)
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 9, 2009 at 2:19 pm
What are the security settings of the linked server?
Are you sure the linked server is pointing at the correct database on the remote server?
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 9, 2009 at 1:55 pm
Lynn Pettis (1/9/2009)
GilaMonster (1/9/2009)
It's do-it-yourself sample data. Values at the top of the post, insert statements at the bottom. 😛 😀
That I think not. Too many data columns 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
January 9, 2009 at 1:53 pm
Lynn Pettis (1/9/2009)
hmmmm, something missing I am. No data I see in the insert statements.
It's do-it-yourself sample data. Values at the top of the post, insert statements at 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
January 9, 2009 at 1:45 pm
Viewing 15 posts - 41,821 through 41,835 (of 49,552 total)