SQL Server Startup
From time to time I see a question asking how to determine the last time a SQL Server was either...
2011-03-25
1,313 reads
From time to time I see a question asking how to determine the last time a SQL Server was either...
2011-03-25
1,313 reads
To mark my 30th Birthday today, as promised here’s a SQL Server Crossword for you to enjoy. You can find the previous...
2011-03-23
1,554 reads
G’day,
When I design a table in SQL SERVER, I like to have a reasonable understanding of how the table will...
2011-03-22
3,044 reads
It’s reasonably well known that you can get different execution plans if you change the ANSI connection settings. But the...
2011-03-21
1,115 reads
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
2011-03-18
2,146 reads
The thing that I most enjoy about going to conferences, SQLSaturdays, and user group meetings is the people I get...
2011-03-17
1,072 reads
I was really excited about the concept of Shared DataSets when they were introduced. My excitement diminished a little when...
2011-03-17
1,767 reads
I was recently asked a question on restoring a database using PowerShell with the following requirements
Take a database backup file...
2011-03-16
2,581 reads
We have been doing some more work with SQL Azure lately, so I have put together a small collection of...
2011-03-15
1,831 reads
If you are thinking about attending SQL Server Connections (a part of DevConnections) in Orlando this March 27-30, take advantage...
2011-03-11
638 reads
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
The post Lukáš Karlovský: I got the green light from management and built Fabric...
Comments posted to this topic are about the item The Pervasive Nature of Open...
Has anyone done a migration from sharepoint integrated ssrs to native? I'm not finding...
What is wrong (if anything) with this code?
SELECT * FROM Sales.SalesOrderHeader AS soh WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS C WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)See possible answers