Server Configuration

Server Memory and The Query Optimiser
Hi guys, Can anyone tell me if the query optimiser takes available system memory into account when deciding how to perform a given query. To take an extreme example, could it potentially come up with a different plan for a server with 256G or RAM versus a server with 2GB of RAM - simply as a result of the a... 8 May 2010 15:38

install sp1 on sql 2008 r2
Hi, i'm a bit confused. I just installed sql 2008 r2 (build 1600) and i need to install the SP1 but my doubt is, what is sql 2008 R2? is it sql 2008 + Service Pack 1? what update does it include with the "r2"? do i have to install sp1 or it's already included? thanks!! ... 5 May 2010 19:25

Login failed on local SQL server
Hi all I've got a SQl server instance on my local pc which I use for development before transferring to test/production servers. I have full administrative rights. I've been using it for about a year with no problems until yesterday. I tried opening SQL server management studio and got the message "Login fa... 5 May 2010 09:20

Microsoft Responds to the Evolution of Online Communities
Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the rapidly-growing forum platform. This decision is in response to worldwide market trends and evolving customer needs. Microsoft continues to invest in forums t... 4 May 2010 22:25

Large table + index maintenance = headaches
Hi, I have a database that's a little over 1 TB in size. Here's the output of sp_spaceused: database_name database_size unallocated space MyBigDB 1331068.69 MB 403552.74 MB reserved data index_size unused 935236744 KB 717736272 KB 216731360 KB 769112 KB About half of ... 5 May 2010 13:48

sp_delete_backuphistory, how does it work
We have a few servers where the backup history (backupset) is a couple of hundred thousand unindexed rows and would like to trim them down. What I want to know is if how the sp goes about it's business when the table is not indexed. The last thing I want to do is tie up msdb for any length of time while the sp pas... 4 May 2010 20:13

sys.dm_db_index_operational_stats
I am a .net programmer, but sometimes get SQL Server DBA tasks as we don't have a DBA. There is a situation where the database seems to lock up occasionally. Below is a row from sys.dm_db_index_operational_stats, where the row_lock_wait_in_ms is very high. Can you please give me some clues as to what would c... 5 May 2010 18:18

creating a connection in VisualStudio
I have sqlserver 2008 installed. I am creating a program in visualstudio 2008, although I have the same problem in VS 2010. When I try to create a connection to the sqlserver the server connection is not listed. Are there any tricks I need to do? thanks for the help john ... 5 May 2010 04:58

To Shrink or Not to Shrink?
I've inherited a bit of a mess. My employer is a majot form but they've never had a DBA!!!!! I've got 30 instances with 600 DBs in total. Unfortunately, none of the DBs were ever sized properly at the outset, so many DBs have too much logcial file space. Now I know it's a DBA no-no to auto shrink, but in my circums... 4 May 2010 13:29

How to find out the point time when the database is damaged/crashe
Hi, I am using SQL 2005. The database backup routines are: 1) Daily full backup (.bak file) at 1 AM. 2) Transaction log backup (.trn files) every 15 min from 8 AM - 8 PM from Monday to Sunday. Let's say the database is damaged (e.g., by mistake, a table was dropped, or some rows in a table were deleted, or the... 5 May 2010 09:20