Ran on most recent partition:

ALTER TABLE xxxx REBUILD PARTITION = 165 WITH (DATA_COMPRESSION = PAGE)

The next partition via split function was also compressed at page level. Only had...

I work for a huge company so getting this to the right team is a challenge, because the problem is experienced within SQL Server, but the problem might be the...

i don't know if litespeed has 30 days free option, but litespeed does allow individual table restore.

DNA_DBA (2/26/2011)

---

You shouldn't really need to shrink your transaction log files; the database has worked hard to make them the size they are to accommodate the work that is being...

I install sql server on D drive. The company I work for doesn't provide a C drive with much space so we install all software on D drive (all...

not sure this helps but

select isdate(Stuff('201101', 4, 0, ' ')) returns 0

http://www.sqlservercentral.com/scripts/T-SQL/72143/

i'd fill test tables with 100000 rows then use that to multiple out to 5,000,000 rows (i think you said 5MM). i mean to populate with real data (maybe...

i've never had to create a newly improved version of the already

built-in role db_ddladmin role, but......

this is the reason i add users to the db_ddladmin role:

DDL Admin role Can...

with the limited description of what you are asking, doubt you'll get an answer.

seems like this might untie your knot:

http://www.texastoo.com/post/2009/10/19/Could-not-load-file-or-assembly-VSTADTEProviderInterop.aspx

as for as i know sql server 2005, you'll need put the user in one of these roles. every time i deal with these roles, i have to re-read...

It would if collation is a matter of case sensitivity (_CS_ vs _CI_).

Or for multiple test environments - we have...

Set them all to run under different user IDs.

Questions are too broad, Paul. I wouldn't know where to start.

As far as SAN goes, however, I doubt you'll have any say in how it is set up. ...