How to remove CardinalityEstimate in query plan on computed columns…
Hello,
I have come across a really good tip if you’re using computed columns that involve a concatenation of columns and...
2014-06-15
734 reads
Hello,
I have come across a really good tip if you’re using computed columns that involve a concatenation of columns and...
2014-06-15
734 reads
Have you ever had the need to select values that are directly on the next line down but drag-and-drop selects...
2014-01-27
294 reads
Have your ever had a timeout error in a visual studio 2012 unit test like below?
How to get around this...
2013-12-18
1,013 reads
Have you ever wanted to evaluate 2 tables in one IF BEGIN END block, I firstly wrote this:-
Which always evaluated...
2013-12-05
365 reads
I’ve been thinking about a question from a application developer regarding generating a unique identifier outside of SQL and persisting...
2013-10-08 (first published: 2013-10-03)
2,642 reads
I’ve been thinking about a question from a application developer regarding generating a unique identifier outside of SQL and persisting...
2013-10-03
485 reads
Has anyone ever though of pushing a SQL Server database backup out remotely? (SQL Native andor RedGate Backups) My idea...
2013-08-21 (first published: 2013-08-16)
4,827 reads
I’m writing a table value function that returns a cdc recordset that, instead of returning changed data row-by-row, I need...
2013-08-19
656 reads
CDC changes column-by-column instead of row-by-row, can you improve it???.
2013-08-19
798 reads
Wouldn’t it be nice if SQL Server allowed this functionality? for instance if did the below:-
I get the above error....
2013-08-19
1,049 reads
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
No two SQL Server environments are alike. A fix that resolves a performance issue...
Comments posted to this topic are about the item Are You Working More Hours?
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Comments posted to this topic are about the item A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers