Viewing 15 posts - 13,216 through 13,230 (of 49,552 total)
As for your performance problem (and please in future post different questions in different threads), can you please post the actual execution plan. What you posted was an estimated and...
May 9, 2013 at 12:38 pm
No useful information in that.
Edit the job, go to the job step, the advanced tab and configure an output file. If the job fails again, look in the output...
May 9, 2013 at 12:36 pm
Kill no.
As for how it works, it would take a few pages to explain, so maybe have a read through the entries in BoL (there's a load of information)...
May 9, 2013 at 12:32 pm
No such things as global variables.
Use the task space usage and session space usage DMVs to identify what's using lots of TempDB and tune the queries so that they don't...
May 9, 2013 at 10:30 am
Look into using resource governor (not query governor), if you just kill sessions there's a fair chance that the people running them swear, curse and rerun the queries.
May 9, 2013 at 10:29 am
Be careful, filegroup backups require that you do have backups of all the filegroups that you intend to restore (and I'm not talking about a dev refresh, more a disaster...
May 9, 2013 at 10:15 am
A full backup is always a full backup of the entire DB. You can do things like filegroup backups and have the CDC tables in another filegroup, but that complicated...
May 9, 2013 at 4:18 am
There's a script in the first article that Igor linked, just take the part to create a new partition and ignore the part to switch and merge the partitions since...
May 8, 2013 at 5:19 pm
Create a job that runs every year and splits a new partition. It's the same as the sliding window except you're only doing the split partition half, not the switch...
May 8, 2013 at 4:40 pm
Case gives you table/index scans. Very consistent performance, but not good performance once you get to tables with more than a couple hundred rows. The OR method can use index...
May 8, 2013 at 4:39 pm
You're looking for the function datediff, however it'll overflow for a value that far back as datediff returns an int and 1900/01/01 is more than MAXINT seconds ago.
This works.
SELECT CAST(datediff(hour,'1900/01/01',GETDATE())...
May 8, 2013 at 11:39 am
Can you be a bit clearer what you want?
Kill all the queries that have been running for 2 hours and have been blocking other queries for 2 hours?
Kill all the...
May 8, 2013 at 8:18 am
The index isn't covering and doesn't even support most of the where clause. Unless a very, very, very, very small portion of the table qualifies for that filtered index, it's...
May 8, 2013 at 8:16 am
Viewing 15 posts - 13,216 through 13,230 (of 49,552 total)