The best solution for that problem is good documentation. You need to know where the packages are being stored and what processes use said packages.

Is this a newer physical server that you have SQL installed on?

thanks for the question

SELECT name

FROM sys.databases

WHERE database_id <= 4

/*

Report Services where collation has not been changed from default

Inclusion of SSRS dbs is questionable as system databases

*/

OR (name LIKE '%ReportServer%'

AND collation_name = 'Latin1_General_CI_AS_KS_WS')

/*

Catch...

Along the same vein as Grant started:

Who does the performance tuning for your SQL Server (tsql etc)?

That will give you a lot more experience

opc.three (3/23/2013)

---

gantavasu (3/23/2013)

---

Here i have configured the mirroring. after that i want to add the data file to primary.

can we add the data file?

if we add is there any impact...

Generally, I'd opt for a single update statement. If that means retyping the calculations for dependent columns - so be it. You create a stored procedure and your...

It largely depends on what your future plans are. If you intend to continue with SQL Server or with creating reports in SQL Server - then the experience should...

ijtroquim (3/22/2013)

---

Now, DBAs come and go and systems get updated. Switches are good. But sometimes more importantly is you know what and more importantly why you want to toggle a...

Eric M Russell (3/21/2013)

---

Eric M Russell (3/21/2013)

---

Good point.

...

Here we are talking about the massive storage and where it might be in 10 yrs or so. I am sitting on the other hand thinking that these large...

Steve Jones - SSC Editor (3/22/2013)

---

Are you saying you want a read only and a read/write role? Separate from db_Datereader/writer?

That's easy to script.

loop through all tables in all databases, grant...

Use stored procedures for any jobs and store the stored procedure in SVN

or

Script the job as a drop create and store that statement in SVN.

crookj (3/22/2013)

---

May...

Thanks Ron