Viewing 15 posts - 42,436 through 42,450 (of 49,571 total)
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic617605-5-1.aspx
December 11, 2008 at 5:08 am
mzakwans (12/11/2008)
hithanks
but I have tried it without delete and every time I do change on exist record it adds all record to the tb2 again
Have you referenced the...
December 11, 2008 at 5:03 am
I'm still not understanding what you want.
The most recent query?
The most recent data change?
Something else?
Best bet to get any of that is to have a profiler trace running for any...
December 11, 2008 at 4:39 am
arup_kc (12/11/2008)
It's showing that it takes 17 ms while using "SELECT *" but only 1 ms while using "SELECT 1"
Well, yes. For the first one, the data has to be...
December 11, 2008 at 4:39 am
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....
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...
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
Viewing 15 posts - 42,436 through 42,450 (of 49,571 total)