Server Configuration

Enabling AWE SQL Server 2005 64-bit - multipleinstances
I am very interested in this discussion. I would like to learn from you all about the guideline for min/max memory configure for multiple instances. My server is SQL2005 64-bit, with 36 GB memory and 16 named instances. Any suggestions or best practices to follow? Thank you, Vivien Xing ... 4 Jul 2008 23:18

Current Job Run Status
I am trying to create a query against a SQL 2000 database to see if a job is currently running. I cannot cancel the job that I am monitoring. Shortly after it completes, I need to notify some people and do some additional work. Unfortunately I forgot to change the job to notify me on completion, so I just want to se... 13 Jul 2008 11:01

select statement with no results is producing locks
If I have a select statement that produces no results, what sort of locks could it still potentially generate? ... 4 Jul 2008 14:07

Result Set from RESTORE FILELISTONLY into #table?
Hi, If I have a table called tblEmployee with columns of diffeernt types, I can do something like this SELECT * INTO #foo FROM tblEmployee; and it will create #foo with all the correct column types and insert the data. I do NOT have to create the table definition first. I now want to do the same with the... 9 Jul 2008 14:45

SQL server transaction timeout and stored procedures
Hi, is there a default transactions timeout when running stored procedures? Basically I need to run stored procedures that could involve 100,000s of inserts\updates and I want to be able to let the procedure run until these are completed. Is this feasible or are there some restrictions. Also is there anythi... 4 Jul 2008 13:05

New SQL Security problem coming next Tuesday
Hi, Yesterday's Security Bulletin Advanced Notice http://www.microsoft.com/technet/security/bulletin/ms08-jul.mspx talks about a patch coming for SQL 7/2000/2005. Wonder if this will be in CU9 for SQL2005? If it is extra to CU7 for SQL2005 it will make my life more complicated as we are just about to put CU7... 8 Jul 2008 14:08

Script to get DB space usage Info.
Hi All, I am looking for a Script which will give me complete space usage information of a particular DB in SQL Server 2000. It would be of great help if I get the script which will give same results as we get in Database diagram. Thanks in advance. Thanks & Regards, Sajid C. ... 7 Jul 2008 10:26

SQL 2005 - Not responding - freezing
Hi, I have SQL Server 2005 Standard on a Windows Server 2003 64Bit Operating System, Dell PowerEdge2900 with 8GB RAM. Once in couple of months, the SQL Server just stops responding for my client requests which my application uses as a backend database. The memory usage of SQL Server goes as high as 4GB out o... 7 Jul 2008 12:30

SQL 2008 Policy management through sql queries
Hi folks, i was wonderign .. is there a way how to find out in which facet is a searched property through some SELECT from a dmv maybe? Eg. in which facet is a property ClrEnabled (its in surface area config) but through some query Thx, Marek Chmel ... 4 Jul 2008 07:57

How to create SQL script of the existing table or database
Hi! Is there a way to create a script from the existing database, Adventure Works for example? I mean, some way to export not only a table structure, for example, but also data into a sql script, so that if I run it, it will create me both table and insert all data. Is it possible to script the entire databa... 6 Jul 2008 01:47