I want to determine who the local administrators are on each of my SQL Servers. Basically, I'd like a nightly job to run against each of my SQL Servers and produce a list of admins for each server for my review. How can I do this?
In the second part of his optimization series, Dave Ballantyne shows us how to add conditional logic to set based, more efficient T-SQL code.
We all know how important tempdb is and know that tempdb gets recreated every time SQL Server is restarted. Here we dig a little deeper to focus on how space is used inside tempdb.
The cloud should bring with it lower costs, and better efficiency, but that's not necessarily the way things are. Microsoft has a great internal project that costs out the cloud for their departments, and this would be a great addition to the public or private clouds.
Learn how you can remove a cursor and optimize a routine that loops through a series of data and performs various calculations in this short article from Dave Ballantyne.
Your job is to generate a string using Forsyth-Edwards Notation which represents the final position of pieces after performing a series of moves from the original position
There is now a vast amount of SQL Server information and 'best practice' advice available on the Internet, in the form of innumerable blogs, community sites and forums. Finding an answer to your question is relatively easy, but finding the right, or best, answer is harder than ever.
In a typical bar chart, the height of the bars represents the value of the data along the X axis and the Y axis represents the category of the data point. All these values can be classified in logical groups depending upon the logic used for analysis. One general requirement that arises in the case of repeating groups, is to highlight these groups without representing it on the X or Y scale. In this tip we will look at how to address this requirement.
Learn to use SQLCLR, parallelism and how to write better performing SQL code from MVP Adam Machanic in New York City on July 14-15. Early bird discounts available with the code "EARLYBIRD".
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers