Be careful. Recursive CTEs can be DREADFULLY poor performers!!

I didn't write the book on UDFs and how bad they are, but I did write the chapter! 😎

SQL Server MVP Deep Dives 2 book, "Death by UDF". They...

Biggest question is Enterprise Edition or not. If so, assuming your 7TB is a data warehouse then I would go straight to SQL 2014, or at least 2012 if...

Note that FAR worse than the 10% log file growth is the 1MB default data file growth increment. If you have that, well, you have a BUTT TON of...

Yes, LOTS of harm. Among the issues are VLF problems (search Kimberly Tripp VLF), stalls while you grow back out, you probably have default 10% growth increment which makes this...

The 1 or 10000 being the same tells me you could almost certainly use an index on something that is seekable to get you down to that 1 row efficiently.

1) where are you trying to compile this sproc?

2) what is the exact error you are having when you try to compile it?

I don't think you really care about "server" information. What you really want to test is the database state. See sys.database_mirroring in Books Online.

I am not sure I understand the question. .mdf files are SQL Server database data files, so you expect them to see lots of activity. Is there something...

Please provide a sample temp table with data that covers all logic cases and your expected output.

Oh, VERY important point: I used TEMP TABLES in my example for you ON PURPOSE. Please don't give people a script that creates permanent tables.

This looks close, but not exact. Note: the way to solve these Aggregate query issues is to

1) do the select * without groupings so you can see all...

we need something like this:

create table #test (a int, b money, c datetime ...)

insert #test (..) values (1, 1.1, '20140101'...)

.

.

.

select blah from #test where ...

actual output:

...

expected output:

...

1) Please provide sample table(s) and data with your actual output and the expected output.

2) This construct is DEVASTATINGLY BAD!! It prevents getting accurate statistics (which will lead to...

Mark Harley (10/30/2014)

---

We're refreshing our infrastructure and I want to take advantage of the situation to finally set up a high-safety/disaster recovery model for our databases. We are a...