Viewing 15 posts - 346 through 360 (of 1,583 total)
At the very least please post the Actual Execution plan and give us some insight as to why you want it to optimize it in the first place - is...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 12, 2014 at 7:31 am
If it were me, I'd give it an "internal" deadline - meaning, pick a date that things need to change by and then make the decision to give your boss...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 11, 2014 at 2:33 pm
+1 Grant, that's where I was heading with my thoughts but very hard to guess at it without any example of the code used :hehe:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 11, 2014 at 1:19 pm
Can you post your code for the function, the code calling the function, and some sample data so I can run it?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 11, 2014 at 7:18 am
Well, add the [name] column to the query?
SELECT QUOTENAME(SCHEMA_NAME(schema_id)) + '.' + QUOTENAME([name]) AS SchemaTable
FROM sys.tables
WHERE is_replicated = 1EDIT Removed the DISTINCT (not needed)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 10, 2014 at 10:19 am
If all that's in there is old records from 2011, you're good to go. These can and should be removed. In fact, by default the size of the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 10, 2014 at 8:17 am
Something like this?
SELECT DISTINCT SCHEMA_NAME(schema_id) AS SchemaTable
FROM sys.tables WHERE is_replicated = 1
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 10, 2014 at 8:10 am
Wow Grant, that "SQL Server 2012 Query Performance Tuning" book is $40- do we get an SSC discount? 😀
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 9, 2014 at 2:45 pm
How about this? You could just both result sets into a temp table or use CTE to select out the results SELECT
ja.job_id,
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 9, 2014 at 2:27 pm
My Bad 😉 Was just teasing:
http://www.mssqltips.com/sqlservertip/2628/how-to-find-outdated-statistics-in-sql-server-2008/
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 9, 2014 at 10:11 am
🙂 I think we've all been in a similar situation so stay positive and don't get personal, stick to the facts and what's best for the company (and your role...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2014 at 4:45 pm
If you have a job that runs frequently that updates statistics, or have auto statistics turned on, then they should be fairly up to date. To see when they...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2014 at 4:43 pm
Include a JOIN to msdb.dbo.sysjobactivity and ORDER BY the run_requested_date DESC - it will return 0 for any job step that is currently executing - example: (SELECT TOP 1 ISNULL(last_executed_step_id,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2014 at 3:05 pm
t's the framework-generated stuff that's a problem (and it has the added benefit of not really being human-readable).
It's TSQL isn't it? You should be able to find the executing...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2014 at 6:20 am
Here's a thought, play devil's advocate: go to the husband who set up and configured the server - Ask him how he configured the storage array: Ask how he aligned...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2014 at 6:18 am
Viewing 15 posts - 346 through 360 (of 1,583 total)