Viewing 15 posts - 5,446 through 5,460 (of 49,571 total)
Service accounts, as in the account that the SQL Server is running as? No way, that's bad practice.
Windows authent is good, I prefer it over SQL authent when possible, but...
July 1, 2015 at 2:44 am
If the DB was in full recovery, and you still have the log file, and you can 'hack attach' the remaining files to a SQL instance of the same version,...
July 1, 2015 at 2:37 am
Jeff Moden (6/30/2015)
June 30, 2015 at 11:32 am
Log reuse reason, or a large tran log, or a 60% full tran log will not cause queries to run slow.
June 30, 2015 at 11:10 am
Jason A. Long (6/30/2015)
(and yes, you are correct... They are bad).
They are not. They are inefficient on large row counts.
June 30, 2015 at 11:07 am
Tac11 (6/30/2015)
Now I get on execution plan with 'key lookup', 'nested loop' operator, which I think are bad.
No they're not. There are no bad operators, if there were they wouldn't...
June 30, 2015 at 11:05 am
Why is this a concern?
June 30, 2015 at 7:55 am
Then there's a delete running somewhere else, from a job or another user or something.
SQL will not delete data by itself. If you have rows disappearing, someone or some job...
June 30, 2015 at 7:39 am
Check the script, see what it's doing. If there are fewer rows after than before, then something in the script you are running is deleting data. Probably your merge script...
June 30, 2015 at 7:03 am
Eeep. Just realised that tomorrow's the 1st of July. Or the 'refresh email every 5 seconds' day.
June 30, 2015 at 4:56 am
DBA From The Cold (6/30/2015)
GilaMonster (6/30/2015)
Koen Verbeeck (6/30/2015)
DBA From The Cold (6/30/2015)
June 30, 2015 at 3:02 am
SQL will not overwrite existing rows because of a table's size. Look at whatever is doing the insert into the table, from SQL's side, if it's told to do an...
June 30, 2015 at 2:55 am
Koen Verbeeck (6/30/2015)
DBA From The Cold (6/30/2015)
I've...
June 30, 2015 at 2:51 am
Viewing 15 posts - 5,446 through 5,460 (of 49,571 total)