Earlier on Beyondrelational I read a tip, for the same topic. combination of keys Shift + Print screen, allows us to take screen shot of Remote Desktop. But recently I faced problem using these keys. It allowed taking print screen only once. Every ot...

SQL Server interprets two-digit years based on a cutoff year of 2049. That is, the two-digit year 49 is interpreted as 2049 and the two-digit year 50 is interpreted as 1950. SQL Server also provides cutoff configurations but Microsoft recommend usin...

If you use "select * into" to create a new table from an existing table having a primary key, then the new table will not have a primary key by default....

Today my colleague came up with a problem that he were not able to restore database having error like follows. Restore failed for Server ''. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: The file "D:\Db.mdf" is compressed bu...

I am working a Data Quality Services Demo where i had to figure out how to write a domain rule to validate a email address. for this task, i re-learned how to write a regular expression; here's my basic version: [A-Za-z0-9._-]+@[A-Za-z0-9.-]+.[A-Za-z...

"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below. Initially thought it's like a cheat code. But its about mastering the basics. In ...

SQL Server always use additional covering index for the best execution plan when table have both normal and covering nonclustered index on it and those column to be qualified for the same.......

SQL Server always use additional covering index for the best execution plan when table have both normal and covering nonclustered index on it and those column to be qualified for the same.......

It can't get simpler than this: Drag the "Email" to the "Tasks" Tab that you can find in Bottom Left corner. What I like about it is that It let's to specify start date, end date, priority, status, reminders. Just wonderful! I have been using it for ...

It can't get simpler than this: Drag the "Email" to the "Tasks" Tab that you can find in Bottom Left corner. What I like about it is that It let's to specify start date, end date, priority, status, reminders. Just wonderful! I have been using it for ...