At sometime in the afternoon today, I was alerted by the business that SQL reporting services is down. The first thing I checked was to open a report. I saw the following error message on the browser. The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError) Log on [...]
Feb
25
2010
25
2010
Oct
6
2009
6
2009
DMV Report for Index Fragmentation and Statistics Update
Recently the ETL load times of my Datawarehouse are increasing and so I decided to check the Indexes status on the tables . I found some fragmentation on the indexes and also some Statistics that are not being updated regularly . I searched online and found this blog by Ben Nevarez(SQL Blog). I decided to [...]
Jun
18
2009
18
2009
Could not allocate a new page for database ‘TEMPDB’ because of insufficient disk space in filegroup ‘DEFAULT’. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup
The error happens when your disk space is full on TempDB.Check the space on the Drive where the TempDb is located . Solutions a.Review the Query and check if it can be better optimised. Some of the Queries’ intermediate heavy datasets are stored in tempdb before returning the results. b.The most easiest way I found [...]
Jun
16
2009
16
2009
Who Receives the Email when a SQL SERVER JOB Fails
Here is a script that gives you the list of operators name who receive notifications when a job fails SELECT sysoperators.name AS JobName, sysjobs.name AS OperatorName, sysjobs.enabled, sysoperators.id FROM sysjobs INNER JOIN sysoperators ON sysjobs.notify_email_operator_id = sysoperators.id You need to change the sysjobs.notify_email_operator_id to change the Notifications of the Operator.
Jun
16
2009
16
2009
Playing with SQL SERVER CACHE
Yesterday Afternoon me and my friend were doing some serious Sql manipulation on some heavy datasets that needs to go inside the Cube.We have written some dynamic SQL statement that is going to insert some 40000 rows into a Control table for a Dimension. Weird Enough my friend accidently closed the Query window and for [...]
May
26
2009
26
2009
Identifying Sql Server Environments using Management Studio
You can identify the SQL server environments using various settings from the Sql server Management Studio 2008. a. Open Management studio b. Press Ctrl + Alt+ G (List of Registered Servers) c. Right Click on one of the Registered Servers –> Properties d. Go to the Connection Properties Section and voila you can see the [...]
May
18
2009
18
2009
Kill the Sql server process for a Database
When Doing database Restore sometimes we may need to kill the spid’s in the database so that the connections are not open. Going through the spids in sp_who or sp_who2 can sometimes be a tedious task if there are more connections to the database. The following TSQL should generate the list of kill statements for [...]
Apr
23
2009
23
2009
Disk Space in Sql server
How to get the Disk Space in SQL Server? There are 2 ways a. xp_fixeddrives — The Easy way b. Ftsutil(xp_cmdshell) — If I want to know the percentage of free space in harddisk use FTSUTIL . The only thing you need to enable is the xp_cmdshell. Click here to read how to enable XP_cmdshell [...]
Apr
21
2009
21
2009
Enabling Xp_cmdShell in Sql server 2008
In Sql server 2008 the Surface area configuration no longer exists. you can enable the Xp_cmdshell either by the Policy based management or by using the sp_configure
Apr
1
2009
1
2009
Deprecated Features in SQL server 2008
Here are the List of features that are deprecated in Sql server 2008 http://msdn.microsoft.com/en-us/library/ms143729.aspx
