Is there any documentation explaning how to setup unattended installation for SQL 2008 along with the following; .NET Framework 3.5 SP1 Windows...
i have enabled trace flag (1222) to capture deadlocks and some how when i run select * from sys.traces - i could only see the default trace runing. I...
<P>I am having little hardtime reading and understanding this deadlock print out. I would appreciate, if someone please take a moment to take a look...
I have a SSIS package all what it does is move million of rows from X database to Y database. X database is residing on Server A and Y database on...
I have one table which contains application admin related settings. this table gets updated by the application on very frequent bases. i was...
I am trying to understand - How SQL Server 2005-64 bit handle memory? Say if i allocated 20 GB to SQL Server - will it grab 20 GB at instance startup...
I am trying to export data from my production SQL box to Dev box and this is what i encounter: - Setting Source Connection (Error) Messages Error...
My SQL Server is 2005--64-bit. Do i need to assign SQL service account to be part of "LOCK PAGES IN MEMORY" policy? Thanks,
My SQL Server performance was very poor and when enable deadlock trace, i see the following in the errorlog file: 2008-07-19 00:00:10.99 spid1...
Is there a way i could see - how much my user database has grown in last 6 months? I am running on SQL 2005 and would appreciaet - if there's a way...
I have users running basic MDX reports against one of the production AS box and the server just hangs and never responds for like 20 minutes. I was...
Is there a way, i could create one cluster index and refer to 2 user tables?
I have 3 questions and would appreciate, if some one please provide some input. Say if i am updating a row in a table and at the same time - other...
We have 5 user's with admin rights on our OLAP Box. I see somebody created a new Cube on the OLAP Server and i was wondering, is there a way, i can...
I am in a midst of consolidating all our SQL Servers and i was looking what's the best Clustering option to go with. Any suggestions would be greatly...
I have a active/active cluster setup. I was wondering, how could i setup notification (Emails - Pager etc) to be sent to DBA's - when one node fails...
On my SQL 2005 - I see total server and target server memory to be equal. Does this mean, SQL Server is under memory pressure?
I am doing a simple insert into a table with the following clause and some how SQL doesnt like it. INSERT into Opr1 Select * FROM TBLFACTOPERATIONS...
I have a production SQL 2005 instance configured with 12 GB of memory. I am trying to see - how much physical memory was used by SQL Server at any...
what features i wont be able to utilize, if i run my databases on sql 2000 compatible mode on a sql 2005 server? These databases are production...
Separate names with a comma.
