Topics
Started by
Posts
Last post
What is the easiest approach to add a user for read -only DB in sql 2005. I know we can alter DB to…
4 replies
I have to migrate all the 10 databases with users having different privileges from one server anoth…
3 replies
I have a couple of questions about Database Mirror that I hope someone can answer for me. I have a…
4 replies
From what I can tell in 2005 I need to query sys.dm_db_index_physical_stats and check avg_fragmenta…
27 replies
IF EXISTS vs if @@rowcount: With IF EXISTS, Clustered Index Update cost is 304%, Clustered Inde…
5 replies
Hi all ... We're in the planning stages of migrating from one data center to a new one, with all ne…
4 replies
Hello How I can replace an 'NOT IN' statement with a left join statement select t.CodClient,t.Nam…
3 replies
Hi, Most dba's use the admin database to keep their backup,restore and maintenance scripts instead …
5 replies
One of my DB Maintenance job (It does reorg and take complete backup of user db) is failing for lon…
6 replies
I have a database called "live" and I want to create a database called "liveview". I want to create…
9 replies
Ok. I'm not too familiar with partitioning and here's what I have. Table1 with millions of rows I c…
4 replies
Hi to all, I have to create all the jobs i have in my databases in productions, to a database in my…
3 replies
Hey DBA gurus: I had this requirement where I am suppose to run all my SQL Servers 2005 under non a…
1 replies
Hi all, I want to take log backups of 20 databases every 15 mins to the location 'Z:\backups\log\' …
3 replies
is there a way to exclude html elements from a full text index
1 replies
Viewing 15 topics - 15,616 through 15,630 (of 22,780 total)
You must be logged in to create new topics.