I will repeat my request for sample data, and it needs to be in the form of a table with rows inserted into it. Give me that and I...

Can't you just do something like this:

SELECT IceRink,Country_IceRink, Name, Gender, Country_Persons, Time, Distance

FROM TbExample

WHERE (Distance = '500' and Gender = 'Man' )

OR (Distance = '1000' and Gender = 'Man' )

OR...

Please provide sample rows and sample output. I would think at a minimum you would need to include the gender and distance columns so you can specify what the...

Don't have time to dig into it right now, but over the years and versions there have been any number of buffer-flushing bugs hit SQL Server. Some of them...

I don't think FULL JOIN would be required. LEAD/LAG should still work...

Look up the LAG or LEAD keywords in Books Online.

Use the right tool for the job. Sometimes that means truncating and (re)loading from scratch is best. Sometimes you don't KNOW what changes to apply so you have...

Adding to the good stuff Grant wrote, be sure you search ALL of your "source code" for each index name you may intend to DELETE!! Failure to do so...

DB1 just has a tiny tlog file. It may or may not need to be bigger. 68% full...

cre8tivedaze (12/13/2014)

---

Thanks for that Kevin. The thing is, the resulting output table will need to be dynamic in the sense that as the database grows (i.e. more years of data)...

Ahh, my favorite TSQL word comes into play here: CASE

Try working something like this into your query:

SUM(CASE WHEN year = 2012 then a.totalWords else 0 end) AS 2012TotalWords,

SUM(CASE WHEN...

Also, I checked the size of the transaction log files, and it's not that big. We have a transaction backup job running every 20 mins, which will shrink the log...

Plan guides don't help with data-value-skew-induced poor performance resulting from a good plan for one input(s) being a (horribly) bad plan for other input(s) either.

I suppose we will...

One solution is to add to the particular sensitive query an "optimize for" hint and supply a known value that gives the desired plan.

Or use "optimize for unknown", so the...

1) I recommend investigating Trace Flag 2371, which lowers the row mod count trigger for auto stats updates for larger tables.

http://blogs.msdn.com/b/saponsqlserver/archive/2011/09/07/changes-to-automatic-update-statistics-in-sql-server-traceflag-2371.aspx

2) No matter what you do this scenario almost certainly...