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 [...]
Displaying posts written by
Vivek
who has written 45 posts for Sqlserver007.
Jun
18
2009
18
2009
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
27
2009
27
2009
Checking the Dependencies in Another Database
I have 20 Databases in my production Server and the tables in some database are used by the Views , functions and procedures of some Other Databases. Now I want to find out the Dependencies of the Tables and their Database Location. I can use the following Dynamic SQL to get the SQL statements and [...]
Apr
27
2009
27
2009
Splitting Website URL in TSQL
Recently I was involved in a task of splitting the URL’s and generating some reference based on them. I started looking around on google and found this function Split from http://www.otecode.com. This Table Valued function returns a list of substring based on the literal you specify as parameter create function [fn_Split] ( @text varchar(8000) ,@Delimiter [...]
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
15
2009
15
2009
Stored Procedures – Output Parameters
Here is how you create a stored procedures with OutPut Parameter The Execution is as follows
