Creating a comma-separated list (SQL Spackle)
Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield.
2019-04-04 (first published: 2011-01-12)
40,518 reads
SQL Spackle
Loading XML Data into SQL Server (SQL Spackle)
Learn how to load data in an XML file into a table in SQL Server.
2013-05-31 (first published: 2011-01-03)
20,177 reads
Hidden Formatting Troubles with STR() (SQL Spackle)
Fill in another bit of your T-SQL knowledge about STR(). It right justifies, rounds, and controls the output width of columns. Sounds perfect but here's why you might not want to use it.
2019-04-26 (first published: 2010-12-15)
15,580 reads
Group Islands of Contiguous Dates (SQL Spackle)
Fill in another bit of your T-SQL knowledge by learning how to quickly group ranges of contiguous dates without RBAR.
2019-04-19 (first published: 2010-12-07)
25,543 reads
Returning the Top X row for each group (SQL Spackle)
One of the most common T-SQL questions is on returning a ranked result set for each member of a group. Dave Ballentyne brings us a short tutorial on how you can do this in T-SQL.
2012-11-23 (first published: 2010-12-06)
29,590 reads
Why doesn’t ISNUMERIC work correctly? (SQL Spackle)
Another in our series of articles to help you fill in the cracks in your knowledge with SQL Spackle. MVP Jeff Moden shows us how IsNumeric works and how you should use it.
2012-09-14 (first published: 2010-12-01)
41,234 reads
Sorting Months By Number (SQL Spackle)
Fill in another bit of your T-SQL knowledge by learning how to sort a result set by the proper month order, but use the month name instead.
2019-04-12 (first published: 2010-11-15)
23,817 reads
RE: Computer grabbing all IP Adresses - is SQL Server instance involved?
Okay, that's a bit different. You say it's choking all the network traffic and it's exposed to the Internet. When you get a chance, if you issue a @@VERISON on it, what is returned? Also, is there anything between the SQL Server and the Internet that provides any filtering... firewall, etc?
2004-04-15
RE: DBCC shrinkfile error - Msg 8985
Try shrinking it using the fileid (SELECT NAME, FILEID FROM SYSFILES), use the same syntax, just replace the filename with the fileid.
2004-04-14
2 reads
RE: Stored Procedure issue
Hi David,I like what you did with the query. It looks much "cleaner" than before. However, I get the following message: Line 59 (highlighted): Incorrect syntax near 'Daily Total'Thank you.CREATE PROCEDURE MTDPerformance3 ASSELECT department, [Date], SUM(CASE [Product] WHEN 'E-Tech' THEN [output] else 0 END) as 'E-TECH', SUM(CASE [Product] WHEN 'E-9' THEN [output] […]
2004-04-14
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers