Viewing 15 posts - 5,026 through 5,040 (of 49,571 total)
Yes, and as I mentioned earlier, there may be cases where it doesn't work because TempDB is not designed to always be recoverable.
August 13, 2015 at 6:08 am
Something like this should work
table1.column1 - (CASE WHEN DATEPART (DW,GETDATE()) = 2 THEN 4 ELSE 0 END)
August 13, 2015 at 6:05 am
SQLSACT (8/13/2015)
Perry Whittle (8/13/2015)
SQLSACT (8/13/2015)
Could you perhaps shed some clarity on why I had to follow this procedure to get model restored?
Because you didn't copy the files from a working...
August 13, 2015 at 5:49 am
There's a number of things wrong here.
Firstly you're not using the inserted pseudotable, instead depending on some column in the table. Use inserted to get the inserted rows and new...
August 13, 2015 at 4:56 am
exec sp_recompile 'ProcedureName'
That said, rebuilding indexes invalidates all plans using the rebuilt indexes and will force a procedure to recreate it's plan. Hence it's likely that recompiling won't fix things...
August 13, 2015 at 4:51 am
Luis Cazares (8/12/2015)
jasona.work (8/12/2015)
August 13, 2015 at 4:16 am
Do the ALTER DATABASE before you take the DB offline.
1) Run Alter Database ... Modify File
2) Take the DB offline
3) Physically move the files
4) Bring the DB online
August 13, 2015 at 4:07 am
vsamantha35 (8/12/2015)
I mean what kind of conversation do I need to...
August 13, 2015 at 2:50 am
Look at a perfmon counter set which was started at the beginning of the week. If you didn't start one a week ago and don't have a third party tool...
August 13, 2015 at 2:48 am
Lynn, I think that may have been unnecessarily antagonistic.
August 12, 2015 at 10:14 am
You can't.
SQL doesn't keep track of the insert time of rows. To delete from a table based on the age of the row, you need a column which records the...
August 12, 2015 at 9:18 am
Gazareth (8/12/2015)
This will give you some info on the triggers & aggregated execution stats.
Bear in mind that the exec_trigger_stats DMV depends on the trigger's plan being in cache. If the...
August 12, 2015 at 9:09 am
mar.ko (8/12/2015)
Well guys, not one of you provided a solution.
Two people explained to you why you were getting null in your print. Your question read as 'why is this happening',...
August 12, 2015 at 9:05 am
Copy the files from a working instance, then restore.
TempDB can't always be recovered, because it's not designed to be recovered on startup, but that's what the traceflag forces. So when...
August 12, 2015 at 9:00 am
Viewing 15 posts - 5,026 through 5,040 (of 49,571 total)