2011-02-11 (first published: 2011-01-31)
2,909 reads
shanu hoosen
List all Columns in Server Part 2
Generates a list of Server, Database, Table , Column Names and properties
2011-02-08 (first published: 2011-01-31)
1,355 reads
List all columns in server
I came across a project which required a list of all columns within a server and thought I would post it here in case anyone else had this requirement.
2010-09-30 (first published: 2010-09-28)
1,534 reads
Blogs
Trace Query in Extended Events
The ability to quickly and easily trace a query is important to database professionals....
Using Erik Darling’s sp_pressure_detector to resolve CPU issues
By DesertDBA
Last Friday I spent my lunch break going through some links I had marked...
How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error
I’ve come across another error message in my seemingly never-ending battle with Azure Key...
Forums
How to import Excel with XML
Hi, I have an Excel sheet that I have to import into SQL Server....
Recursive CTE - Batches
Hi Folks I'm trying to group rows into batch and adding batch to query...
XQuery - Use column value to display correct node
Hi All First time with XQuery and despite trying to read as many guides...
Ask SSC