Koen Verbeeck (2/27/2014)

---

There's a new developer conference in Belgium: Techorama (which replaces two conferences: the Community Day, an organization of all the user groups, and TechDays, a scaled down TechEd-like...

Since tempdb is a total dumping ground, I'd be seriously hesitant to use it in this fashion. I'd look at some other mechanism for caching this common data, possibly not...

You can go to zero free space if you want. There's not magic "acceptable" answer. The issue is, why do you need to shrink the database? Was there a broken...

You have to then look at the query plan to determine where things are slowing down and how you...

A much, much, less accurate mechanism would be to capture the information from sys.dm_exec_query_stats. You can see the last executed date there. That will show you what has been called...

sqldriver (2/27/2014)

---

Grant Fritchey (2/27/2014)

---

Just remember that any of the conversions can prevent the use of statistics which makes the possibilities of scans on the data much higher.

Best practice is, like...

I've never found Intellisense to work adequately. Another tool to try is SQL Prompt[/url] from Red Gate Software.

Just remember that any of the conversions can prevent the use of statistics which makes the possibilities of scans on the data much higher.

Best practice is, like to like comparisons...

Just remember that enforcing referential constraints doesn't just ensure good, clean data. You also get performance enhancements when the query optimizer knows that foreign key constraints are in place and...

You've pretty much outlined what SSIS was built for. But, there's no automatic way to do it. You'll have to build the processes by hand.

It sounds like blocking and resource contention. You'd need to monitor the server to see which queries are the ones that are being slowed down and then determine what resources...

I'd suggest using a T-SQL script to restore from. Whatever mechanism is changing the backups nightly is surely discernable, and therefore repeatable. You can then just run the restore. There...

quackhandle1975 (2/26/2014)

---

Grant Fritchey (2/25/2014)

---

The one suggestion I can offer to cut the time is to just do a statistics update, not an index rebuild. You actually don't even have to...

P Jones (2/26/2014)

---

Also answers such as "I'd get on the SQL Server central website and see what others who have faced similar problems recommend examining" show a readiness to learn...

The only part of that statement I would disagree with is outputting trace data to a table. I wouldn't recommend that. I would output it to a file (or more...