Importing a CSV into SQL Server Shouldn't Be This Hard
A frustrating time importing CSV files leads Steve to test the different options.
2021-07-14
6,443 reads
CSV
Get a CSV list of columns in a table
Short little script to get the columns in a table in order into a CSV format.
Can be useful for select or insert statements.
2016-08-30 (first published: 2015-03-23)
2,834 reads
Blogs
Using Framing for a Running Total–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Accessibility in your PowerPoint slide deck
This post is part of the series I kicked off here. You can read...
Daily Coping 28 Jul 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Error shrinking database
While trying to shrink a database using the command "dbcc shrinkdatabase ([db_name])", I get...
Are Powerplans still relevant for VM servers?
Hello, I am rolling out a new monitoring environment. While in testing, it is...
SELECT records from table 1 that does not exist in table 2 via UNION
Sorry if this seems too beginner; I have been stuck at this for days...
Ask SSC