The normalisation then ERD then simple querying test is something we use as a norm in our interviews for DB bods including DBA's. We give them a simple form of...

SSD's do indeed need system RAM but with 1 TB of RAM.. well it doesn't really matter does it.

Have a look at Wesley Browns article on Fusion SSD's on SQLServerCentral.

http://www.sqlservercentral.com/articles/SSD+Disks/69693/

1K...

Depending on the Service pack level there is a bug in both SQL 2005 and SQL 2008 with xp_readerrorlog. The rollback message you get is also spurious.

Once xp_readerrorlog gets hung...

Greg Larson has written an article with a good base of scripts for performance metrics, they are flexible and gives you the groundwork to add additional metrics as you like....

I work for an independant government body and things are worse - our pay has been frozen for last 2 years and probably this coming year (this adds up to...

One thing that doesn't seem to have been mentioned.

As far as I remember the Enterprise edition (report server version) of CR requires an ActiveX object to be installed on the...

I'd agree with thesuda on the complexity of the product, but the licensing is pretty much on par with things like BO and OBIEE if not slightly cheaper and at...

I can tell you something about Qlikview and no.. I don't work for them.

The organisation I work for used Qlikview for about 4 years as a reporting tool for a...

This should do it for you, I take no credit for it, it is mainly someone elses code (whose I cannot recall) that has been slightly amended.

The DBPcnt column is...

I had the same problem a few moons ago with a cluster an outsourced IT company added disks to but they forgot about the SQL Server part - doh!

I found...

I started as an IT Analyst/Developer about 20 years ago (the analyst part was system and server admin, the Developer was mainly SQL and 'C' ), then moved to Network/Server...

SQL Mail has always been a bit of a pig.

This is culled from some FAQ I stumbled across many moons ago when I had the same issue.

You must have apermanent...

In my experience the HR dept is frequently by-passed and a quid-pro-quo exists between the IT Manager and his/her IT workers. This quite often because IT depts quite often do...

hmmm.. I prefer select @@version

gives you everything - all the service pack, build and edition info as well as microsofts dinky little copyright messages.

🙂

I have experienced SQL 2005 64bit Standard Edition doing a similar thing as you describe especially when our data analysts are crunching very large datasets. The results are; All connectivity...