I just created an ndf file for my database placing it on a diffrent drive and now want to move some large tables to that new ndf file. How can i...
Here is my setup for link server Server4 = KERBEROS/Standard/Mixed Mode/delegation set to 1 Server5 = KERBEROS/Enterprise/Mixed Mode/delegation set...
I will be doing cross server queries most of the time and i want to set up linked server with windows authentication every where. for example I login...
Any one has scripts to automate DB Index rebuilding. I dont want to run rebuild all the indexes in a db but i want to rebuild only those which are...
How could i tune this script without using cursors.DECLARE @AuditItemID int,@AuditItemName varchar(100),@IsGroupHeader bit,@GroupHeaderHasItems...
How best I can tune this on 2005 without using cursors, can anyone advise me.Declare @errorCode int,@rowc int, @StartTime SmallDateTime, @stepMarker...
How can i insert into Blob field which contains 15mb of data for each row, without locking the table.
SELECT CombinedTT.Level4Description, CombinedTT.EmployeeName, CombinedTT.PunchType, CombinedTT.DepartmentDescript,...
Looking for help on performance tune forthe stored procedure. plese check the link below...
I have a table with column days(varchar(255),null) which has data like 1;2;3;4;11;18;17;10;9;8;7;14;15;16;21;22;23;24;25;30;29;28. these are the...
I created a view with cte WITH UserGroupUserGroups AS ( SELECT CAST(NULL AS UNIQUEIDENTIFIER) AS ParentUserGroupID,...
I have 4 tables Users{userid(pk),name,no} GroupUsers{userid(pk),usergroupid(pk)} UserGroups{UserGroupid(pk),Name}...
How can i find a table,column name from a DB which was updated most recently
how can i enforce a constraint where the user has to enter only 1 digit after decimal point, if its entered like 0.65 then it is an error. it shud be...
The follwing proc is running nearly 1min.44sec ,i wud like to run it more faster.. content may be mispelled its just an example ALTER PROCEDURE...
SET @sql=' select @email=email from pvcomp.dbo.tbloffice where office=''+@dbname+''SET @email=select email from pvcomp.dbo.tbloffice where...
How can i check for tenths of an hour. I wud like to know if the time entered into the column is in tenths of an hour?
1st proc CREATE PROCEDURE mailsecurity @dbname varchar(20), @name varchar(10), @emp varchar(4), @Admin char(1) output as begin set nocount on...
A small change in the proc... 1st proc CREATE PROCEDURE mailsecurity @dbname varchar(20), @name varchar(10), @emp varchar(4), @Admin char(1) output...
Separate names with a comma.
