Here’s a sample script for rendering query results as XML: – Declare a variable with the XML datatype DECLARE @myXml xml – Use FOR XML AUTO syntax SET @myXml = (SELECT [states] FROM … more →
metamythianKendra wrote 1 day ago: This post is about a really little detail that isn’t a big deal. But to me it actually is a li … more →
Paulo Condeça wrote 1 month ago: SSMS (SQL SERVER MANAGEMENT STUDIO) slow startup and how to optimize SSMS startup time : To sump up, … more →
Benny Austin wrote 1 month ago: Analysis Service Security model is role based and relies on Windows authentication. This could pos … more →
rlb wrote 2 months ago: I had a lot of trouble finding these two programs while remote desktoping into a Windows Server Mach … more →
Ron wrote 2 months ago: I recently upgraded to SQL Server Management Studio 2008. (I LOVE the Script as … Drop and Create fu … more →
smitashree wrote 2 months ago: My day started bit early than usual at 6.30 . Around 8.00 went for breakfast and found some more mem … more →
pinvoke wrote 2 months ago: A few evenings ago I had the awesome opportunity to re-start the Phoenix Azure group. I am really l … more →
Syed Mehroz Alam wrote 3 months ago: There are two ways to restore a differential backup in SQL Server: Directly use TSQL statements as d … more →
Ron wrote 3 months ago: I needed to change the default directories for SSMS (SQL Server Management Studio) 2005, and it took … more →
grammarrocker wrote 5 months ago: SSMS J-Day 2009 Gallery I need to make a tag linky thingy for SSMS or J-Day Write a caption Typi … more →
Kendra wrote 6 months ago: There’s some pretty cool things about SSMS 2008– Activity monitor is pretty great now. I … more →
MarlonRibunal wrote 6 months ago: NOTE: This is stolen from ServerFault.com. I have copied it here for a convenient source for those w … more →
Karlo Bartels wrote 6 months ago: Today I created a stored procedure to find out if a particular SQL Server Job was running or not. I … more →
honeyvirus wrote 7 months ago: Starting SSMS is easy..just Run ’ssms’. This client tool for SQL Server helps managing t … more →
mylli3bab3y wrote 8 months ago: Hello there! To start off, i am in middle school. I go to SSMS( Sawgrass Springs Middle School). I … more →
Karlo Bartels wrote 8 months ago: Creating XML documentation for T-SQL Download SQLDoc Lite Popular tools like Sandcastle and DocProje … more →
akarimomar wrote 9 months ago: Getting a long lost senior calling you is indeed a surprise. But getting two long lost seniors calli … more →
Aaron Akin wrote 9 months ago: After I first installed SQL 2008, I tried to connect to SSIS 2005, and to my surprise, received the … more →
Aaron Akin wrote 10 months ago: It had always bothered me when I opened a SQL 2005 Integrated Services instance to find an SSIS pack … more →