Hi,<br /><br />We are planning to implement filegroup backup strategy for one of our big database. We are planning to divide the database by dates so...
Hi, We have 2 databases and same table in both databases. On database1 this table is heap with no indexes and on database2 it has primary key index...
Hi, Following are the sample tables and data: create table trans (id_trans int, template int, instance int) create table base (id_base int, n_base...
Hi,<br /><br />We are using both views and indexed views in our application but lately we are seeing that sql server is not using optimized plan for...
Hi, We are creating a procedure in which we use bcp(xp_cmdshell) to archive out the data for particular month. When I execute procedure without...
Hi, I am trying to write a sql where I don#%92t want to select row if value of column col3 is character ‘a#%92 followed by digits 0 to 9 but...
Hi, Our database is in full recovery model and we are running a long script that contains: insert statement truncate statement bcp statement select...
Hi, This is the scenario: create table dd(id_acc int,id int,parent int,amount int) create table dd1(id_acc int,id int,parent int,amount int)...
Hi, We are planning to rebuild our indexes as they are too fragmented. I need some suggestion for setting of fillfactor for clustered and...
Hi, We have a oltp database and we create reporting database for each month. so every month one new database is created dynamically and tables are...
Hi, We are seeing probems with using @resample for following 2 scenarios: 1) We run the update statistics for all tables using syntax: update...
Hi, In profiler we can easily trace the parameters passed to the procedure and output values....but if we have nested procedures ..how can we trace...
Hi,<br /> <br />We are getting following kind of errors when doing lots of insert/select:<br />Time-out occurred while waiting for buffer latch type...
Hi,<br /><br />We are planning to order following books. It will be great if u can provide ur feedback -if we miss any book or any book is...
Hi, We are having deadlock when 2 users(processes) try to execute proc1 at same time using DTC(SERIALIZABLE). With trace 1204 we are able to find...
Hi, Do SELECT..INTO and other minimal logged operations are only minimally logged in BULK-LOGGED model or also in Simple recovery model. i tested it...
Hi, We have a procedure like this: create proc proc1 @abc int .... as set nocount on begin... some business rule check here.... exec proc2 --exec...
Hi, We want to test the setting of affinity mask on out queries. we have 2 xeon processor machine so it looks like 4 processors.....i want to use...
Separate names with a comma.
