You can use the query hint:

[font="Courier New"]SELECT

*

FROM

MyTable

OPTION (MAXDOP 1)[/font]

It will depend on the situation. If, for instance, you have 10 inserts and you need to check @@Error after each one, using one TRY-CATCH block will be faster,...

Take a good look at your query. The columns used in the joins are all candidates for needing an index. Without some kind of realistic data, I cannot...

I work with Oracle daily. In Oracle, NATURAL JOIN will join two tables by all columns that have the same name and data type (actually it is really "compatible"...

I need you to post something that will generate test data. The Left/Right Extent design does not make any sense to me and I do not want to waste...

Of these about only 10 columns are ever used in vast majority of scenarios and these are all indexed columns......

I am not sure if you meant anything by including the...

That's not a pivot. It is really string aggregation.

Take a look here for a big list of options:

http://www.projectdmx.com/tsql/rowconcatenate.aspx

Given an appropriate table design and indexing, I do not see why you would not be able to query the table and get results quickly enough.

Perhaps you can post the...

If you right-click on the Job Agent node in Management Studio, you can set the amount of history stored in the Job Agent properties.

This is for all jobs, but if...

You should use the system stored procedures (sp_help_job). Microsoft can (and does) make schema changes to MSDB without much notice.

I can see that, but I would not go overboard on this one.

They probably are not changing daily. I would script them, not allow them to be created through...

Unfortunately, every situation differs.

Is your linked server environment that large and constantly changing? I would think source control for the changes would be overkill, but I suppose if you have 30 linked...

RAID 5 is pretty slow, I would try to avoid it.

Disk setup can be a bit complex as you want to do your best to provide SQL different physical drives...

From you workstation:

-Running a package in BIDS runs in an environment in which all components are allowed (Enterprise Edition of SSIS) and the packages are run using your NT credentials

-Running...