Yes, you are right. I had overlooked that. Both rewrites of the ORDER BY are incorrect, it needs to be kept as it was (with the ISNULL or with a...

Does the database have a huge transaction log file? Instant file initialization applies to data files only; log files always have to be zeroed.

Does the create database script from TFS...

Instead of guessing, I recommend you open the queries and stored procedures (or packages if you use SSIS) used in the ETL process. Looking at the code allows you to...

Without knowing more about your loading process, it's hard to really comment.

Generally, a staging table is where possibly dirty data is loaded; after that it is cleansed and the clean...

MMartin1 (2/4/2016)

---

The problem with assigning an auto-incrementing id as the primary key is that it does nothing. Imagine a data entry typist accidentally leaning on the keyboard for a while,...

Sergiy (2/4/2016)

---

Hugo Kornelis (1/21/2016)

---

Not true. Without a clustered index (i.e., in a heap), SQL Server...

The only way to ensure that users with the rights to create databses or create backups stay within...

Gianluca, how will using this stored procedure be more useful to the OP then just adding a jobstep at the end of each job to start the next job?

Your question is not clear. And changing midway from TableA to Horses doesn't help either.

Please visit this link: http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/%5B/url%5D to find out what information we need to help you, and...

If you already have ten jobs in Agent that work fine, and now you want to make them run sequentially, then use what Michael posted and what I explained:

* First...

I didn't go over all your modifications, but this one just struck my eye.

I think you intended this to be:

ORDER BY MC.TerminationDate DESC, MC.EffectiveDate DESC

Tuning is never simple, and especially tuning a complex query such as the one you posted can be a challenge.

You say that you want to replace the OUTER APPLY. Why?...

georgheretis (2/4/2016)

---

thanks

i want in series but i need probably to create an new job in sql server agent in order to run it

so can i create an new job called...

PS: Yes, I know that was blunt. Please pass it on unchanged to whoever asked that question of you.

If you give a recommendation and it backfires, it will be your...

So the initial size may be anything from 5MB to 200TB?

And the growth can be anything from none at all to 5000 Yottabytes per hour?

And you probably have no information...