Viewing 15 posts - 5,026 through 5,040 (of 49,552 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.
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
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)
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
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...
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
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...
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
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...
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
August 13, 2015 at 4:51 am
Luis Cazares (8/12/2015)
jasona.work (8/12/2015)
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
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
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
August 13, 2015 at 4:07 am
vsamantha35 (8/12/2015)
I mean what kind of conversation do I need to...
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
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...
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
August 13, 2015 at 2:48 am
Yup. Completely equivalent.
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
August 12, 2015 at 3:31 pm
Lynn, I think that may have been unnecessarily antagonistic.
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
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...
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
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...
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
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',...
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
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...
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
August 12, 2015 at 9:00 am
Viewing 15 posts - 5,026 through 5,040 (of 49,552 total)