It should be set to 1.5 times your RAM amount. This was best practice in '95 and still is today. Better yet set it to system managed and forget about...

Are you installing on W2008 or W2008 R2? If you are using W2008 R2 then you need to build a slipstreamed media set that includes SQL Server 2008 SP1....

Remember that the key thing with the resource database is that it is a...

I agree with George that trying to move SQL to another server with a different drive layout is a risky thing to do. If you want to do this...

My employer moved to Agile development about 15 months ago. One of the real benefits we see is the greater involvement and communication between 'the business' and IT. ...

Another approach is to create a lookup containing both values and labels.

The label you show in the report drop-down can be formatted with leading spaces or whatever you...

ORM tools are here to stay, at least for a few years until the next big thing. So is Cloud. Both concepts spin the line that specialist skills...

I am sure I have set this up in the past, but I do not have a suitable...

I think Moki has covered most angles, but a couple of things need more clarification.

If the job owner has sysadmin authority, the job always runs under the SQL Agent security...

Paging is done by Windows. SQL Server cannot tell Windows to page or to not page any of the SQL Server memory. The 'lock pages in memory' right...

Shrinking a database will have no impact on the log space used when you rebuild an index. If you are rebuilding a large index you will use a lot...

Many security practitioners are close to paranoid about product administrators doing their work without needing Windows superuser or product superuser rights. IMHO the documentation from Microsoft needed to achieve...

Try looking in the SQL Error Log for the startup messages. This could give you the information you need.

Ajit, are you aware that SQL Server automatically indexes every row as it is added to a table. There is no need to do a separate index build in...

To access mainframe files, you will need an appropriate ODBC (or similar) driver. Google may help you find what is available, but I believe a company called NEON can...