Supercharge Your SQL Server Scalar Functions By Switching To Table Value Functions
User defined functions in SQL server can cause all kinds of performance problems, there are however some tricks that are...
2019-01-18
261 reads
User defined functions in SQL server can cause all kinds of performance problems, there are however some tricks that are...
2019-01-18
261 reads
Scripted Simulation of SQL Server Loads
When blogging, presenting or testing an idea, one issue I constantly have is that my...
2019-01-17 (first published: 2019-01-11)
2,312 reads
I know, I know your data could never possibly have duplicates because obviously, you have all the constraints in place...
2019-01-09 (first published: 2019-01-03)
2,975 reads
I’ve done a few posts on Clustered and Non-Clustered indexes before, what I’ve not however covered and something that is...
2019-01-09
229 reads
OK, so profiler isn’t actually dead, it has however been deprecated since 2012 and has had no new features since...
2019-01-07
254 reads
Indexing on In Memory OLTP tables is a little different from your traditional on-disk rowstore tables…
In Memory Differences…
There is no...
2018-12-24 (first published: 2018-12-04)
2,743 reads
Since SQL 2012 some really awesome new technologies have been introduced into the engine that are massively underused. Everyone is...
2018-12-19 (first published: 2018-12-03)
2,253 reads
Every language handles null equality differently and understanding this is crucial as a misunderstanding here can lead to some quite...
2018-12-14 (first published: 2018-11-29)
3,164 reads
In the interests of curiosity I’m going to take a query that runs a relatively simple aggregation over a large...
2018-12-10
290 reads
Since SQL Server 2014 SP1 we’ve had DMV’s that can support Live Query Statistics (Basically a query plan that gives...
2018-12-06 (first published: 2018-11-24)
3,358 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers