Viewing 15 posts - 42,436 through 42,450 (of 49,566 total)
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...
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,...
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...
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?
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?
December 11, 2008 at 12:22 am
See if you can match the entries in the log to a job.
Running on a SAN?
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...
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...
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...
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...
December 10, 2008 at 12:37 pm
Chris Morris (12/10/2008)
GilaMonster (12/10/2008)
I do have a couple of fairly...
December 10, 2008 at 8:52 am
Maybe wrap the datediff in a case, when 0 then 1 else datediff...
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...
December 10, 2008 at 7:56 am
swathi (12/10/2008)
Gail Shaw,Server has total of 3.12 GB memory and from which sqlservr.exe is taking 1.7gb which is the maximum among all the processes that r running at that time.
Nothing...
December 10, 2008 at 7:51 am
Viewing 15 posts - 42,436 through 42,450 (of 49,566 total)