2012-06-26 (first published: 2012-06-07)
1,437 reads
2012-01-20 (first published: 2011-12-16)
1,010 reads
Return CSV column in separate rows
This script can be used to return a csv column such emails in separate rows
2011-12-26 (first published: 2011-09-14)
1,528 reads
2011-12-08 (first published: 2011-11-23)
1,128 reads
2011-08-04 (first published: 2011-07-25)
3,164 reads
2011-07-12 (first published: 2011-07-01)
1,126 reads
Remove tab,line feed and carriage return frome text field
Remove tab,line feed and carriage return frome text field
2011-04-28 (first published: 2011-04-21)
3,319 reads
2011-04-27 (first published: 2011-04-21)
2,735 reads
Query to get tables with no clustered indexes
Query to get tables with no clustered indexes(2K5,2K8,2K8 R2)
2011-02-14 (first published: 2011-01-28)
1,831 reads
2011-01-17 (first published: 2011-01-05)
7,135 reads
Blogs
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Forums
How do you keep track of the purpose for SQL Logins?
Wondering how others keep track of the purpose for SQL Logins? I'm not talking...
Just a rant about the SQL Server 2022 upgrade
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
Report Server Configuration Manager - The target principal name is incorrect SSL
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers