Get Information on Current Traces Running
This is just a quick informational query to save as a snippet to get some quick information on running traces,...
2014-12-02
935 reads
This is just a quick informational query to save as a snippet to get some quick information on running traces,...
2014-12-02
935 reads
I was looking for an efficient way to eliminate overlapping days when provided with a historical table that provided events...
2014-10-16
860 reads
If you want to create sample random samples when dealing with date calculations to test your results, you can easily...
2014-08-12
512 reads
Common date values you may need to reference that you may not want to write from scratch each time.
Hope...
2014-08-12
1,042 reads
A step by step explanation on one way to get a consecutive period of months, which could easily be adapted...
2014-05-19
643 reads
Ran across a comment the other day that scalar functions prohibit parallelism for a query when included. I thought it...
2014-02-11
845 reads
If you run across migrating or copying a database structure for some purpose, yet need to change the database references...
2013-08-13
1,923 reads
I’ve never really used the F1 key for help files with most applications. I was surprised at the usefulness in...
2013-07-24
853 reads
If you have a set of columns inside your table that you want to allow nulls in, however if one...
2013-07-18
1,217 reads
When dealing with large amounts of objects in a database, navigation can be tedious with SSMS object explorer. This extender...
2013-07-16
734 reads
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers