andre.quitta (1/29/2014)

---

I've also been evaluating monitoring software. Spotlight has changed to an instance pricing model, which could get pretty expensive pretty fast. We were quoted about $1,500 per instance. There's...

I had a similar situation with a month-end read only database created for an application.

I did several steps:

1. Compress all the tables in the database (partitions for older years in...

Database snapshot files are sparse files that show an allocated size the same size as the database file that are a snapshot of, but typically use much less space on...

Debora (1/28/2014)

---

Getting "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value." error when running the below script:-

delete from table

WHERE CONVERT(datetime, cast([year] as...

Since a TIMESTAMP column is 64 bits, the number of possible unique values = 18,446,744,073,709,551,616 ( 2 to the 64th power ).

Certainly a very large number.

A table with a...

If you are doing connection pooling, the API stored proc sp_reset_connection does not reset the transaction isolation level, so it is important to make sure you reset the transaction isolation...

You can run the script on the link below to see the sized/used/unused space for each file in the database, and to see the size of the individual tables.

Script to...

Why don't you just store the files in SharePoint?

It is probably best to avoid money...

Using float in a calculation can cause problems because it is base 2 internally, so there can be issues with casting to display in base 10. For business calculations,...

Casper101 (1/17/2014)

---

Hi,

The shrink commands I used were:

DBCC Shrinkfile(dataFileNameHere,1)

DBCC Shrinkfile(logFileNameHere,1)

DBCC Shrinkdatabase(databaseNameHere)

The result of the query:

FileSizeMBUsedSpaceMBUnusedSpaceMBDBFileName

341463.06120929.25 220533.81 ***data

132.88...

It would be helpful if you posted the results of this query so we could see where the space is being used

-- Show Size, Space Used, Unused Space, and...

TDE will protect from two main threats:

Using the database backup files to restore somewhere else and looking at the data.

Copying the database data files, attaching to another server, and looking...

TDE cannot be used with compressed backups, so you may need more space for database backups and they may take longer to run.

There is another possibility: Use the four LUNS to create a single volume on the server for the database datafiles.

The data would be spread across the four LUNS automatically...