2016-03-14
90 reads
2016-03-14
90 reads
The age old question of where should business logic be stored
2015-10-16
290 reads
I had an update statement that took 3 minutes to run after this code change it took 6 seconds.
2015-03-27 (first published: 2014-05-08)
31,342 reads
2015-01-26
12,026 reads
I inherited a database that was getting large and not performing well. After adding primary keys life got better.
2014-06-30
14,412 reads
Some people set their default database to the database they use most often. This can cause issues when a restore fails.
2013-11-14
7,479 reads
Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.
2011-11-21
5,838 reads
Recently Ben Kubicek created a script that would allow him to copy his production db to a test instance and correct the production specific SQL code in stored procedures and views.
2010-02-03
7,421 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers