Multiple CTEs
Multiple CTEs
It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you can...
2012-10-11 (first published: 2012-10-09)
4,591 reads
Part II - Louis Davidson (Dr SQL)–Designing for Common Problems in SQL Server…continued
The PASS Data Architecture Virtual Chapter will host part II of Designing for Common Problems in SQL Server by Dr....
2012-10-09
600 reads
Comments on the SQL in the City Tour
There’s still anevent in Seattle in a few weeks. As I’ve been traveling around the country, literally around through New...
2012-10-09
1,367 reads
T-SQL Tuesday #35 – Soylent Green
This month’s host is Nick Haslam (b | t) and he bases his question on the movie Soylent Green, which I...
2012-10-09
970 reads
Retrieving Driver Information
Recently, I had a need to take a look at all of the drivers for a specific set hardware on...
2012-10-09
446 reads
Interview with a #SQLPASS Candidate – @NTSSUG’s Sri Sridharan!
Last week, Sri Sridharan (Twitter, blog) and I sat down on the Internet to talk about his run for the...
2012-10-09
708 reads
MDS Error: “Cannot insert the value NULL into column ‘Code’”
In Microsoft Data Services (MDS), when running a stored procedure to process a staging table (stg.udp_name_Leaf), I received this error:
“Cannot...
2012-10-09
1,259 reads
My PASS Board Vote
I’m not a politically minded person and this is not the type of post I would normally write. However, I’m...
2012-10-09
775 reads
SQLSaturday #171 Pittsburgh recap
This past weekend I made the drive from Cleveland to Pittsburgh to attend SQLSaturday #171. They picked the perfect time...
2012-10-09
576 reads
Reminder to Register for the Monday Night Networking Party
We just crossed the 100 mark for registrants for our Monday Night Networking Party and still room for more. If...
2012-10-12 (first published: 2012-10-09)
1,819 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Alamat BCA KCP Tanah Abang Blok B Telp:0821°8200°233
Telp/Wa 628218200233 Gedung Pasar Tanah Abang Blok B Lantai 5 Kios Nomor 3, 5,...
Alamat BCA KCP Juanda III Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Ir. H. Juanda 3 No.34, Kb. Klp., Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCP Jembatan Lima Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Kh. Moch Mansyur No.15 F, RT.4/RW.1, Duri Sel., Kec. Tambora, Kota...
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers