Ads 720 x 90

Featured Post

Microsoft SQL Server Licensing - abstract

Microsoft SQL Server Licensing – abstract Terms used: An OSE is an Operating System Environment. A POSE is a Physical Operating System Environment. A VOSE is a Virtual Operating System Environment. General rules SQL Server licenses are assigned only to physical servers. The number of SQL Server instan…

Microsoft SQL Server Licensing - abstract

Microsoft SQL Server Licensing – abstract   Terms used: An OSE is an Operating System Environment. A POSE is a Physical Operating System Environment. A VOSE is a Virtual Operating Sy…

What's the best PAGE_VERIFY setting

I always set this value to CHECKSUM. When CHECKSUM is enabled for the PAGE_VERIFY database option, the SQL Server Database Engine calculates a checksum over the contents of the whole page, and stores…

SQL Max Memory Limit Too Low: Increase SQL server Maximum Memory from Command Prompt

SQL Server is well known for being a memory hog. When installed, the default configuration allocates a ridiculous amount of memory (2147483647 MB) to the instance. In effect, this grants SQL Server a…

How to recover space from a huge transaction log file

Most of the novice dba’s forget to take the transaction log backups, which eventually ends up consuming a lot of disk space. This is one of the questions people ask me very often. Here are the steps …

Backup database to disk = ‘Nul’

To understand what this is doing, first we need to understand what Nul is, in the context of a file. It is not just a misspelling of NULL. DOS, since the earliest days, has had a number of devices …

Identifying Unused Databases

This is one of the issues the consultant faces, when there client has little documentation on the systems and the databases they use.  The first step in this process is simply looking at the date &am…

Difference between DateTime2, DateTime and SmallDateTime

Here are the main differences you should know about these three date types:   Range of Dates Accuracy Size usage …

SQL Maintenance Plan error “Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.No global profile is configured. Specify a profile name in the @profile_name parameter.”

Some body have this error : Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.No global profile is configured. Specify a profile name in the @prof…

SQL agent DCOM errors Event ID 10016

Here is the work around to resolve this error (Works on SQL 2008, SQL 2012 ) Click Start -> Run -> dcomcnfg Component services –> computers –> my computer –>DCOM config->MSD…

How to select max row value using TSql

Someone asked me this question and it took me a while to figured out the solution. It look very simple with the new features available in SQL Server 2008. Here is the example     if object_i…
Newest Older

Total Pageviews

Subscribe Our Newsletter