We have a SQL 2008 cluster, and are having increasing, sporadic,and constant timeouts and dropped connections. Even with our local SSMS on the server...
We have a 64-bit SQL Server and have assigned Lock Pages in Memory. As soon as you add the “Lock Pages in Memory†privilege for the service...
Ok,this should be fairly simple, but I'm missing something. Most of this could be derived out of the DMV sys.dm_os_wait_stats. CPUTime +...
Have some questions as we figure out best practice disk layout of sql server on SAN 1. Does SQL benefit from increased drive letters? The 3Par...
Hi, all: I have a planned upgrade from 2000-2008 upcoming, and need tips on what I need to know for sp_configuration settings. For example,...
I have a question. I know, that you can log ship upstream from SQL Server 2000 to SQL Server 2008 but you cannot Log Ship downstream from SQL Server...
I am installing a SQL Server 2008 instance on Windows 2008 Cluster x64 bit. It got all the way to the end of installation and then error: Cluster...
Hi, so I got a system exchange, and I went from XP to Window 7 (64bit), and now I can't seem to install SQL Server 2008. W7 comes with .NET 3.5, and...
Here is what I did, please tell me where there issues are: 1. Created two SQL 2005 servers (primary & User) 2. Created a DB on each server...
I need the best method for updating changes one way, based on a timestamp column. I can't use replication, b/c the databases will be refreshed...
What is the best way to copy a billion rows from one-table to another in SQL? Could I use an INSERT INTO...SELECT? - how would this affect...
I'm trying to come up with a solution. Have a DB around 1TB+, that receives Batch update/loads throughout the day. This of course slows to a crawl,...
hi. i've been looking for a way to enforce the ownership of a sql agent job via the Policy Mgmt framework. If for ex, you want to have all your...
Hi, I would like to know. Is there an easy straightforward way to take the XML output for the ShowPlanXML and display it in a web page as appears in...
hi, forum: I know that this may not be the best forum, but hoping the wide array of experience can provide some help. I have an ASP web...
<P mce_keep="true">hi,forum: Please advise. <BR><BR>Basically we have a x64-bit active-active cluster, and on one node, it is going down with some...
Hi, Forum: Need some help ASAP! Trying to set up a linked server from SQL 2005(64 bit) to SYBASE v.15.0 (32-bit). I have the ASE drivers installed...
Hi, Forum: PLEASE HELP ASAP! I set up a simple SSIS package via the Import/Export wizard, saved with "DoNotSaveWithSensitvePW", scheduled it as a...
Hello, forum: I'm looking for a way (command (sp) or script to monitor and/or provide status on DB mirroring, and to tell which dbs are being...
Separate names with a comma.
