Viewing 15 posts - 42,421 through 42,435 (of 49,552 total)
Peso (12/11/2008)
Haven't anyone noticed that column alias SOURCENAME has different values for the two UNIONed queries?Change UNION to UNION ALL, because the two queries will never return same record values.
Sure....
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
December 11, 2008 at 4:34 am
sandhyarao49 (12/10/2008)
Is it possible to read the transaction log file or is there any specific way to read the transaction log.
Sure. SELECT * from fn_dblog(null, null)
Don't expect it to 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
December 11, 2008 at 1:00 am
arup_kc (12/10/2008)
It was my notion that while I am using "SELECT *", it returns whole resultset. Naturally, taking more system resources rather "SELECT 1" because it returns only 1,...
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
December 11, 2008 at 12:40 am
Casper (12/11/2008)
This will seem like a stupid question, but is it possible that those other MDF and LDF files could be used/referenced by anything else - besides the actual DB?
If...
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
December 11, 2008 at 12:27 am
mohd.imtiaz (12/10/2008)
i dont want to use subquery
Why not?
Is the query too slow? It is using excessive resources? Causing blocking?
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
December 11, 2008 at 12:25 am
I'm not sure I understand you. How do you want to 'identify' a transaction? By last, the one that began most recently, ended most recently, something else?
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
December 11, 2008 at 12:22 am
I believe this doc has most listed
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
December 11, 2008 at 12:19 am
See if you can match the entries in the log to a job.
Running on a SAN?
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
December 11, 2008 at 12:14 am
Joe (12/10/2008)
Thanks for the reply;GilaMonster;
I want to encrypt the entire DB so that if someone steal the DB, then they are not able to attach it or restore it;
For 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
December 11, 2008 at 12:11 am
Lynn Pettis (12/10/2008)
Instictive is the key.
Indeed. My first instructor was once observed tripping on a flight of stairs (while running down), doing a perfect forward roll down 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
December 10, 2008 at 1:08 pm
Chris Morris (12/10/2008)
It looks so risky, rolling over forwards surely makes you feel vulnerable to neck injury? I wouldn't want to try it sober!
Feel, maybe, though done properly though 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
December 10, 2008 at 12:43 pm
One thing to note is that no transactions are actually rolled back. What checkDB is doing is creating a hidden database snapshot to do the check on and the transactions...
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
December 10, 2008 at 12:37 pm
Chris Morris (12/10/2008)
GilaMonster (12/10/2008)
I do have a couple of fairly...
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
December 10, 2008 at 8:52 am
Maybe wrap the datediff in a case, when 0 then 1 else datediff...
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
December 10, 2008 at 8:06 am
I don't have any photos of what Steve's taking about. I was too busy getting pounded into the mat by Kalen.
I do have a couple of fairly good photos from...
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
December 10, 2008 at 7:56 am
Viewing 15 posts - 42,421 through 42,435 (of 49,552 total)