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...
Recently i changed my design with table partitions where i have data according to the year. 1. Can i hava full backup once and just backup only...
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...
I dont see any benefit from WHILE LOOPS, how about using CTE's, i guess that wud work though am not much into CTE's.
How best I can tune this on 2005 without using cursors, can anyone advise me.Declare @errorCode int,@rowc int, @StartTime SmallDateTime, @stepMarker...
yeah Satya but I am more concerened about locking the table while inserting. I dont want the table to be LOCKED. thanks
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,...
Madhivananna Can i expect some more help on the split function. thanks
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
thank you guys..i got it done by modulo operator. am just checking time%36000<>0 and it works
instead of a constraint how can I check the values in the DB through a store proc. I mean how can i do this inside a proc
Separate names with a comma.
