Tag Archives: T-SQL

Setting SQL Server Maximum Memory

One of the dafter defaults in SQL Server is the Maximum Server Memory (MB) – set to a value of 2147483647. Who has a server with 2PB RAM? Give me a call if you do – I want to have … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , | 2 Comments

T-SQL Tuesday #85 – Backup Compression

T-SQL Tuesday time again. First one I’ve taken part in for over a year – oops. This time, Kenneth Fisher (blog|@sqlstudent144) is hosting a blog party about backups. So here’s a quick post about Backup Compression. Backup Compression Told you. … Continue reading

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , | 2 Comments

Which databases were backed up in which backup task?

It’s a confusing question / title / headline. Let’s see if I can clarify what I’m after. For each scheduled backup job, which databases were backed up? And (more to the point) which databases weren’t backed up? And how can … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , | 3 Comments

SQL Jobs – On a Calendar?

SQL Server backup jobs are IO-intensive, he says, stating the obvious. When you have a lot of servers which have been set up over the years, and you’re new to the environment, and want to see when storage is being … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , , , , , | 18 Comments

The TImes, They Are A-Changing

No, not the song. Nor the reference in Watchmen. But the clocks. Y’know, that primitive thing where we have to put the clocks back an hour in the winter and push them forward an hour in the spring? That. What … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , | 1 Comment

45 Database Performance Tips for Developers

Just a quick post to point out that Red Gate has just put out an e-book of 45 Database Performance Tips for Developers. It’s free. And to sweeten the deal, they’re bundling it with a 14 day free trial licence … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , , , | 1 Comment

SQL Saturday 194 Exeter Pre-Con – T-SQL and Internals

OK, Yes, it’s another post pimping a SQL Saturday 194 Exeter Pre-Con session. This time, a quick look at the Two Daves and their session on T-SQL and Internals. Now, I’ve not had the pleasure of attending a full day … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , | Leave a comment