borra2005 (2/24/2010)

---

Hi,

I have an SP, with in that SP there is a transaction, when i try to call another SP which is in other data base ans has a...

You may be interested in an article on the this topic by me: Deleting large number of rows from a table & a heap in a VLDB[/url]

Read It (3/29/2011)

---

I liked the article. I'm a bit confused by your numbers though. You said make note of the original data and log file sizes and then...

Kathy Massey (3/28/2011)

---

We are testing if our Server goes down how long would it take to be back up & running.

Scenario - Transaction Replication Server1 is Publisher/Distributor

Replication runs fine on...

Hello!

Thank-you all for your interest, and valuable feedback.

Some of the points mentioned in the feedback are really great. I will research them and update the article as necessary.

However, for some...

Excellent question, with an excellent (If I may dare say, better than BOL) explanation!

Have a wonderful day!

That is because they are not supported by the naming conventions for identifiers....

I couldn't agree more. Whenever I carry out code reviews, especially for junior members of the team, I typically find these to be the most common errors they make. I...

I believe the reasons SQL Servers allows you to create the stored procedure are:

1. Procedure names must comply with the naming standard of Identifiers (mentioned in the link provided by...

The two most commonly used options are:

1. OPENROWSET - http://msdn.microsoft.com/en-us/library/ms190312.aspx

2. Use Linked servers, as Garadin pointed out

If I understand you correctly, you need an aggregation, and then an aggregation of all aggregates (or more commonly, a summary row). You may want to try exploring the possibility...

Thank-you for this great question! Because I started off with main-frame COBOL, I went with common sense (even before the SQL mind took over) and came to the conclusion that...

I have not worked on maps, but this article will get me started!

I have just gone through it once, and it is indeed quite thorough - must have taken a...

blandry (3/3/2011)

---

Actually, if you really think about it, how insane are we all to put up with patching at all? What other industry, let alone software company, do you...

I completely agree with your assessment of the matter, Steve. Pressures do causes ISVs to chrun up patches faster, but we have seen that they are generally "band-aids" to stop...