Tag Archives: SQLTip

Filtering SQL Agent Jobs

I suspect that any developer who has been near a SQL Server for more than just a short while, you will be able to recognize a list of SQL Agent jobs that can no longer can be seen in its full … Continue reading

Posted in Programming | Tagged , , | Leave a comment

How to Process Multiple Dimensions via BIDS and SSMS

This is one of those tips I need to write down, before I forget… Sometimes Analysis Services acts up and you need to do a process full on all the dimensions in the database. When that happens I usually turned … Continue reading

Posted in Programming | Tagged , , | 1 Comment

Never loose your server list in SSMS again…

Having to install new laptops, re-install old ones, configuring virtual servers or whenever you get the opportunity to install SQL Server from scratch, you always end up with an empty list of servers, when you try to connect through SQL … Continue reading

Posted in Programming | Tagged , , | 3 Comments

SQL Server Quick Tip 26 – 30

[Blog]: So you think you need Enterprise Edition, huh? http://t.co/zRWoumqRQf #DBA #SQLServer #SQLTip #in — Jens Vestergaard (@vestergaardj) July 4, 2013 A ratio between the size of max_server_memory and the size of the buffer pool extension of 1:16 or less … Continue reading

Posted in Programming | Tagged , , | Leave a comment

So you think you need Enterprise Edition, huh?

Lately I have been struggling on a specific server in an environment I have been working on. Due to the need for partitioning in the cube, the project demanded an Enterprise Edition of SQL Server 2008R2. The only installation available, … Continue reading

Posted in Programming | Tagged , , | 2 Comments