|
|
-
|
|
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....
|
|
-
|
|
Today, we will talk about a slightly different, yet very common subject. We will talk about what are the different ways to measure the number of rows in a table. I found a couple of posts over the Internet, and I will reference them as and when I demonstrate the associated methods. This post basica......
|
|
-
|
|
Ever since I started working with Microsoft SQL Server, I have heard and read a lot about the coveted “Microsoft Certified Professional” status. I had yet to get my first certification even after working with SQL Server for the last 7 years. As the year 2011 dawned, I had made a resolution that no m......
|
|
-
|
|
My blog on BeyondRelational.com (BR) is completing two years today! Here's a quick snapshot of the splendid & exciting journey that these two years have been....
|
|
-
|
|
Microsoft SQL Server comes with a whole range of system databases, which I visited in my post – How to programmatically identify system and user databases on a SQL Server instance. System databases are special, and there some very specific and peculiar characteristics of each (documentation for whic......
|
|
-
|
|
It is a well-known recommendation and best practice that the transaction log of any database must be on a drive different than the data files are on. This is especially useful to improve transaction log file performance, which manifests itself as a high value for the LOGBUFFER wait type. Refer Pinal......
|
|
-
|
|
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!...
|
|
-
|
|
Any database should follow a certain set of properties, collectively called ACID properties - Atomicity, Consistency, Isolation and Durability. Answer this simple question regarding ACID properties and SQL Server databases to win up to two (2) Pluralsight training codes!...
|
|
-
|
|
As a part database developer myself, I am sure that what I am about to document today will be useful to almost everyone who has ever written a stored procedure for with indexed tables for SSRS reporting or massive batch processing. What I will be trying today is to find an answer to the dilemma – Sh......
|
|
-
|
|
Whenever we talk about inclusive date comparison & filtering in T-SQL, the only two options that come to mind are the BETWEEN clause and the greater than (>) and less than (<) operators paired with the equal to operator. Today, let us attempt to find out if there is a difference between the two.......
|
|