Sql Server : How to query the edition or license level of Sql Server

Posted by Sqltimes
On July 26, 2014
0 Comments

Quick one today: More frequently that I would like, we keep getting these questions from customers. “What Sql Server Edition do we have in our production / Development environment?” There are many easy ways to check, I’ll list a couple here. Using T-SQL 1 2 3 4 5 6 7 -- -- Sql Server […]

Posted by Sqltimes
On July 19, 2014
0 Comments

Quick one today: How to get a list of objects (or indexes) that are compressed or have COMPRESSION enabled? I frequently use the below script to get a complete list. Just modify it as needed to fit your specific need. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 […]

Posted by Sqltimes
On July 12, 2014
0 Comments

Quick one today: How do we assign permissions on TABLE TYPEs to user accounts? Earlier last week, this was a point that needed to be covered in our deployment code. We had permissions script that lists out permissions for each database user on all the objects. Since we recently started adding TABLE TYPE’s, this was […]

Posted by Sqltimes
On July 5, 2014
0 Comments

Quick one today: Earlier last week, I was playing with one of our customer databases in our lab environment. As part of implementing table partitioning, some tables changes were necessary; Moving data from one set of tables to another. In the middle of running those scripts, this error occurred: Msg 1105, Level 17, State 2, […]

Posted by Sqltimes
On July 2, 2014
0 Comments

Quick one today: Sometimes, in our lab, we need to do some preparatory work before doing the actual work. This involves loading or moving large volumes of data from one table to another or something similar. While in the zone of doing such activities, the transactional log gets full and my work gets stopped in […]

Sql Server : How to query the edition or license level of Sql Server

Sql Server : Query all the indexes or tables that are COMPRESSED

Sql Server: Assign permissions on table TYPE to users

Sql Server Error Messages : The transaction log for database ‘tempdb’ is full due to ‘ACTIVE_TRANSACTION’

Sql Server : Transaction log full in tempdb and user database (tidbits 2)