Terry B (6/22/2009)

---

I looked at the properties of each table in the DB and the total size of all tables adds up to about 4 GB. How can I...

Thanks Steve for the link. Doc says it's available only in enterprise edition in sql 2k5. I somehow couldn't find it at that time.:-D

Generally i've seen restoration from disk is much faster than those from tapes. After all, you take backups for situations where u might need to restore faster in case of...

Tom John (6/22/2009)

---

I am talking about developers debugging through programs that access the database. So, they will run native SQL queries and also be able to see data retrieved...

Well, Jeff's queries are like that, Rocket speed execution. 😀

Sudiendra (6/22/2009)

---

What do you prefer? i have more than 100 databases sitting on the same server and 5-6 databases are over 100 gigs and rest are small.

Normal full backup...

Tom John (6/22/2009)

---

Unfortunately, it isn't an encryption problem. It has to do with privacy laws and the use of third party contractors and maybe out-of-country developers. So, these...

I guess u do masking on your front-ends. Databases must store actual values. You might want to consider encryption if you need ur certain column to look encrypted. SQL 2k5...

Oh yeah. Thanks for mentioning that point Steve. It's available in enterprise edition only.

I believe if the partitioning is done properly, conflicts can be avoided to a large extent.

Also, Identity...

if u're writing like

select col1, col2.... from table1, all...

i had similar issues. I tried setting up with GUI (configure security) and saw that authentication mode was 'negotiate' and it worked perfectly. I tried using certificates but no help.

my...

You may want to go through Jeff's article on tally table once and see if you can use some of the logics in ur case.

http://www.sqlservercentral.com/articles/T-SQL/62867/

normally you reorganize your indexes if fragmentation is between 5-30% and rebuild if fragmentation>30%

Ref : http://technet.microsoft.com/en-us/library/ms189858.aspx

I suggest you keep reorganizing as a part of maintenance plans and rebuilding on...

Glad I could help 🙂

select * from information_schema.tables

OR

select * from sysobjects where xtype='u'

This will give table details from a specific database.