Satya, This from the above DOC 281122 "It is not necessary to apply a transaction log backup if SQL Server can determine that the files or...
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...
yes fullscan all tables and indexed views
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...
Satya, Database is in full recovery mode......how can checkpoint reduces the %used transaction log until i do the backup? Thanks --rubs
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)...
Is the default fillfactor for non-clustered index is 70% or 100% --rubs
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...
Twan, This works thanks a lot. But problem in our case is that in outer procedure we have some varaiables..we assign values to these variables...
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...
It is already in books that we have.
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...
Separate names with a comma.
