Tracer tokens are really just for confirming that "yes" latency is poor (or good depending on if things are running smoothly). How large is your set up (i.e. how...

What's a performance review? :hehe:

Ummm. RCSI? What's that?

I faced the same issue here at this company. Prior to coming on board here I had never used the hint, but here's it's literally in every reporting procedure...

I know this is probably a retarded way to go about it, but got it to work using this:

CREATE FUNCTION [dbo].[fx_FolderExists] (

@Folder nvarchar(500),

@Action tinyint

)

RETURNS int AS

BEGIN

DECLARE @Exists int, @ObjFile...

Thanks for the suggestions guys! I'll take a deeper look over the next day or two and see what I can come up with!

This would work, however wedging it into the current query looks like an dreadful task. For the basis of my example I used @String to parse, but in relation...

Darn. Missed that one. Had it stated "In 2014 can you run SQL Server in your existing data center and store data files for a database in the Azure...

Yes you can simply take another full backup. Full backups do not affect the LSN chain for log backups in any way (except for the very first full backup...

That works, howeve, in the unlikely event there's stuff going on in the milliseconds portion of the datetime, I would opt for >= 1st day of the month and <...

Thanks Perry. I realize it was supported, just wanted to make certain there was no "behind the scenes" issues with the rename. Appreciate the assurance!

Yes, it should, but as sqlbuddy mentioned, it could be blocked for a variety of reasons. Try extending it to 180 for testing purposes only (or zero for no...

ramana3327 (4/15/2014)

Correct me if I am wrong. I think covering Index is nothing but adding columns that are participating in the where clause right? What about the include columns. What...

Do you have the resource governor running on this...

You database has the space that you've either "given" it or is based upon your auto-growth settings. If you ran out of space I would guess that you have...