Useful T-SQL queries and scripts to work in SQL Server
This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script...
2018-12-05
3 reads
This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script...
2018-12-05
3 reads
This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script...
2018-12-05
1 reads
This post is about some queries and scripts that I use in my daily work on SQL Server. Some of...
2018-12-26 (first published: 2018-12-05)
5,523 reads
Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are aimed for the beginner-level T-SQL developers. Always Use a...
2018-11-17
Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are aimed for the beginner-level T-SQL developers. Always Use a...
2018-11-17
1 reads
Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are...
2018-11-28 (first published: 2018-11-16)
4,406 reads
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right...
2017-12-28
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right...
2017-12-28
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases...
2017-12-28
868 reads
The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be run in different time zones. Services have to consider...
2017-08-18
By Kevin3NF
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...
(If you’d like to read my other T-SQL Tuesday Retrospective posts, click here.) In...
Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can...
This is kinda hard to explain, maybe I can make sense of it. So...
Dear friends, Please, could you give me some ideas, how to implement SELECT count(*)...