Frankly I think the trend has recently shifted in favor of MS SQL. Earlier MS didn't have a strong contender in the DB space unlike Oracle. However more companies are...

Jeffrey Williams-493691 (8/6/2011)

---

I am biased towards SSIS also...found I can get much better performance and manage space using SSIS much easier than using linked servers.

That is the other thing I...

Nope , Do you get any errors when BIDs Hangs.

You might want to reinstall MSXML 6.0

Are you using a named query or are you simply referring to the table in...

it might be useful if you give an example such as

Before : dbo.getallobjects.storeprocedure.sql

After : sbo.getallobjects.sql

The naming convention your using looks like the one VS uses when creating objects in...

There are a number of ideas mentioned in the ebook "How to become an Exceptional DBA".

Its a good place to start on knowing what it takes.

Am not sure if this is what your looking for , but most case the connection would have something like

dbconn.Open()

and

dbconn.close()

if an error is thrown due the the db...

How would you like the below scenario to work

Insert a row with id 1

Insert a new row with select max( id ) +1 hence the new id =...

I have had to do this kind of activity in the past at which point I restored the entire DB on a different box and queried out the data from...

It would be better to create a SSIS package to archive the data you want or You could simply create a replica table on the same server and have a...

Like grant said the application has to initiate a new connection , however database mirroring allows your to failover automatically to another server in case the db is down ,...

There are a number of tools that help perform Admin activities overall ( including backups and audits etc) there are some even specific to SQL Server security but I haven't...

You can use identity insert ON if you want an exact replica of the row from the second db , however if you want to insert just the data without...

http://msdn.microsoft.com/en-us/library/ms190276.aspx

http://msdn.microsoft.com/en-us/library/ms186992.aspx

the above two article explain how operators work. You need to group operators using brackets to make sure you get the required results.

e.g

GO

SELECT ProductID, ProductModelID

FROM AdventureWorks2008R2.Production.Product

WHERE ProductModelID = 20 OR...

Charindex and substring together will get what you need.

charindex finds the position of the letter your lookingfor , (in...

Brad Mcghee cover certification and its role in a DBA's career in this ebook how to become an exceptional DBA. You should probably go thru it to give you n...