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
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
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.
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,...
Can i expect some more help on the split function.
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
these are the...
I created a view with cte
WITH UserGroupUserGroups AS (
CAST(NULL AS UNIQUEIDENTIFIER) AS ParentUserGroupID,...
I have 4 tables
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.