|
|
-
|
|
Do you know when your SQL Server instance was restarted? Can you find it using a simple T-SQL query? Today I share some of my learnings around the sys.dm_server_services DMV; while also documenting the known method of using sys.sp_readerrorlog to read the SQL server error logs....
|
|
-
|
|
How do you script your database objects using T-SQL? I explore 3 different methods that I know about in this post....
|
|
-
|
|
When working on terminal server environments, have you faced a situation where you had to use the SQL Server Profiler to filter trace events based on the Windows Login/User Name? Using my 10-part tutorial series on Profiler as a base, I demonstrate how the SQL Server Profiler provides four columns that can be used to realize this requirement....
|
|
-
|
|
When using the SQL Server Profiler, do you know how to filter multiple objects of the same type? Using my 10-part tutorial series on Profiler as a base, I demonstrate how the SQL Server Profiler facilitates the usage of the "AND" condition when defining column filters....
|
|
-
|
|
How many databases can be hosted on a SQL server instance? How large can a SQL Server database be? Is there a limit to the number of records in a table? Answer to these capacity planning questions. Also - How do you calibrate your systems?...
|
|
-
|
|
How do you extract Day of the Year, Day of the Week and Week Number values from a given date using nothing but T-SQL? In this post, we look at how the DATEPART function can be of help in achieving this requirement....
|
|
-
|
|
Does creating a primary key always create a clustered index? Can a clustered index be created using a column other than the primary key? SQL Server has not such relation/rule between primary keys and clustered indexes....
|
|
-
|
|
Did you know that the SQL Server Management Studio (SSMS) has a built-in XML editor? Chances are that you launch the Visual Studio IDE to edit XML documents even though the SSMS is up and ready to go. Learn about the underappreciated XML editor feature of the SSMS in this post....
|
|
-
|
|
What kinds of locks are acquired by SQL Server during Index Maintenance? Why is the underlying table not available during a REBUILD, but available during a REORGANIZE? Read this post to know more!...
|
|
-
|
|
Any maintenance activity requires some amount of dedicated resources. SQL Server uses locks to reserve resources for a particular task and maintain isolation between transactions. Answer this simple question regarding locks and index maintenance in SQL Server databases to win up to two (2) Pluralsight training codes!...
|
|