2023-02-06
6 reads
Alter Column
2023-02-06 (first published: 2023-02-03)
9 reads
2023-02-03 (first published: 2023-02-02)
8 reads
SQL Server 2016 Online ALTER COLUMN Operation
Learn about the time savings, blocking scenarios, limitations and more for the SQL Server 2016 online ALTER COLUMN operation.
2017-04-07
3,544 reads
2014-09-02
2,057 reads
2012-04-25
3,650 reads
2010-07-14
5,196 reads
RE: Better way??
That worked much faster. It is now 4 seconds instead of 24. It seems I need to learn more about derived tables. I thank you very much.
2005-03-11
Single quotes in VARCHAR and TEXT
Hello, I'd like to hear your opinion: What is the best way to handle single quotes in strings, stored in a DB? I have been asked to help create English version of texts, that appear on a webpage; all these texts are stored in a table in SQLS database, and are always displayed to user via web […]
2005-01-09
61 reads
RE: Question of the Day for 10 May 2004
I have to agree with ALZDBA. Despite BOL saying that the names must be fully qualified it sure looks like the execution plan is being cached and reused. Jamie
2004-05-10
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