Viewing 15 posts - 766 through 780 (of 1,583 total)
How detrimental really depends on what's in the cache. FLUSHPROCINDB is specific to a certain database and doesn't affect any other databases in the procedure cache. Depending on...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2013 at 12:09 pm
My only guess is that this database has a lot of "changing" data. Your differential backup contains everything since the last full backup so if it's nearly the same...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2013 at 10:09 am
Your differential backups will include everything since your last full backup and will grow daily (which you already know), check your transaction log file size, it could be that it's...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2013 at 9:44 am
midnight251 (2/10/2013)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2013 at 7:57 am
I wasn't positive it was a linked server problem or if it was the way I was presenting the code (clearly the poor performance is the direct result of going...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2013 at 7:52 am
Paul, I will try the code and post back the results soon. As for obvious issues with the linked server (remote query) this will go away. All of...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2013 at 10:15 am
Yes, good catch. Based upon Lynn's suggestion I changed the code to store the data from the CTE's locally...so now I do use both CTE's as I insert the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 8, 2013 at 9:30 am
I opted to your temp tables, creating an index where needed and got the update down to about 23sec. - do you think I would see any further improvement by...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 7, 2013 at 11:25 am
You can define them to hold data, data let's say you want to pass to a proc or a function (as OPC stated). Consider this usage:DECLARE @test-2 AS ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 5, 2013 at 8:02 pm
These links should help:
General:
http://msdn.microsoft.com/en-us/library/ms175527(v=sql.105).aspx
http://facility9.com/2009/10/an-introduction-to-sql-server-system-databases/
TempDB:
http://www.idera.com/Downloads/WhitePapers/WP_Demystifying%20tempdb.pdf
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 1, 2013 at 10:19 am
I'd recommend you create a lookup table containing available slot times, and store your records for the main table with the FK to the slots table that point to them
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 1, 2013 at 10:15 am
There's also a built in executable that's shipped with SQL Server. Here's the basic syntax and a link to an article[/url] that describes how to use it
"C:\Program Files\Microsoft SQL...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 1, 2013 at 6:13 am
Also Bhuvnesh and Vedran have made excellent points. To give you a rough idea, I have nearly the same size DB, I use Idera's SQL Safe software (backup compression)...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 1, 2013 at 6:08 am
Use this code (as Grant mentioned, from dm_exec_requests) - it's pretty accurate and will give you a rough idea of when it will complete once you let it run for...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 1, 2013 at 6:01 am
Also, note the threshold being checked:
'WHERE
b.Sql_Severity <> 0
AND run_date = REPLACE(CONVERT(VARCHAR(10),GETDATE(),121),''-'','''') '+
'AND [run_time] >= '''+REPLACE(CONVERT(VARCHAR(20),DATEADD(minute, -20,GETDATE()),08),':','')+''''+
' ORDER BY [run_date],a.[Name],b.[step_id] '
This only goes back 20 minutes, if you want...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 1, 2013 at 5:50 am
Viewing 15 posts - 766 through 780 (of 1,583 total)