Dealing with a long string
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...
2014-06-25
2,645 reads
Wanted: Senior DBA or Dev-DBA (And So Darn Hard to Find!)
I mentor, teach, and consult about SQL Server. It’s an incredible tool –it is an extremely flexible, adaptable, and complex data environment. SQL Server is capable of bringing tremendous...
2014-06-25
13 reads
Wanted: Senior DBA or Dev-DBA (And So Darn Hard to Find!)
I mentor, teach, and consult about SQL Server. It’s an incredible tool –it is an extremely flexible, adaptable, and complex data environment. SQL Server is capable of bringing tremendous...
2014-06-25
12 reads
Wanted: Senior DBA or Dev-DBA (And So Darn Hard to Find!)
I mentor, teach, and consult about SQL Server. It’s an incredible tool –it is an extremely flexible, adaptable, and complex...
2014-06-25
472 reads
SQL Server – Script to Identify and Update Database Auto-Growth Setting
An auto-growth event is the process by which the SQL Server engine expands the size of a database file when...
2014-06-25
1,110 reads
Finding Checked Out Files in TFS
There may be an easier way, but this was a quick way to find ALL the checked out files in...
2014-06-24
1,470 reads
Space Used by Database Files
Retrieve data about size and space used for all the files in the current database with this script.
Some tips on...
2014-06-24
782 reads
No Files For You
No Files For You is another Question Of The Day. I ended up making this one just a little more...
2014-06-24
483 reads
PASS DBA VC Session 25th June
It’s always an honour to be able to speak at an event, but events can be expensive to attend and...
2014-06-24
693 reads
Fix for index corruption issue || SQL Server 2012 Service Pack 2
ISSUE : FIX for Data loss in clustered index occurs when you run online build index in SQL Server 2012
Microsoft release...
2014-06-24
899 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
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
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