Detach attach is the problem because if process failed detach the database is not exists. If rename failed you have the old database working

We are using connection pool. There is no direct customer connections.

Your reaction is true and is not true at the same time. Leap year should have two dividers - 100 and 4 (known fact)

We talking about balance between practice and...

Your reaction is true and is not true at the same time. Leap year should have two dividers - 100 and 4 (known fact)

We talking about balance between practice and...

Your reaction is true and is not true at the same time. Leap year should have two deviders - 100 and 4 (known fact)

We talking about balance between practice and...

eletuw (23/09/2007)

---

I am unable to see the code posted on this article. What is the problem with the web page? I clicked on the link for the txt file and...

I think sometime, thorough reading is required to see the ideas.

"I am not pretending to get the best solutions - the article just shows some...

It all depend from the data analysis. In most cases, if table is not lookup table, it is not a bad idea to have index on FK column(s) because it...

3 columns are forming the key - tx_id,product_id,fiscal_yr_id. You should look at selectivity of the first and combination of first and second column. If this selectivity is right you should...

If DBA is not in total control of table indexes then .......   I can understand that dba is not always in control with database design but nobody tells dba where...

Lets start from the beginning. [NameKey] [nvarchar](341) NOT NULL.  Looks like the choice of column for the clustered index is very bad. Looks like update/changes to the table are never...

There is no way for our customers to run their own query. There are scheduled jobs and applications that using stored procs only.

Customers do not see it because connections are coming fro the connection pool and pool reistablish it right after. Worst case scenario that customer must hit refresh button. As I...

The size of the database is 5-10G. But remember that there is the whole day to backup and restore because after rename happened the LOAD databases required only for the next load in 24...

SQL Cursors are very useful and powerful because they offer a high degree of row-level data manipulation, but this power comes at a price: negative performance. In simple cases there...