I am trying to write a query that will show me all sessions that are connected to a specific database. sys.dm_exec_sessions does not have the...
There are some developers in our organization that like to write the SQL in their stored procedures like this: SELECT ... FROM ... WHERE 1 = 1 AND...
I am in the midst of configuring our new database servers and I am curious about how to place tempdb's files. We have seperate arrays for data, logs,...
The SQL Agent, SQL Reporting, and SQL Integration, services will no longer start on one of my SQLServer 2005 servers. The SQL Server service is still...
Would there be any benefit to storing text and image data in a seperate filegroup from the main data if that filegroup is going to be on the same...
When you go to register a server in Enterprise Manager or connect to a server in Query Analzyer you can see a list of all SQL Servers. How does this...
I want to take the results of msdb.dbo.sp_help_job on multiple servers and import it into a table my DBA Repository database. When I went to do this...
I am having an odd problem with a stored procedure. When I execute the procedure from Query Analyzer or our application, I am getting a NULL for a...
I recently used this statement to reindex two non-clustered indexes on a table containing 27 million rows. I fully expected each reindex to take a...
A DTS package has an owner sid on it. I used sp_reassign_dtspackageowner to assign ownership of the package to a login that is a Windows group...
I have a database role called ur_test and I granted that role execute on some stored procedures and select on a few tables. The following statement...
Is there any way to allow a user to open a DTS package and view it but not execute it? I have taken away all the rights that public has by default...
I have read that it is recommended that you have at least one tempdb data file of equal size for each processor you database server has. So if I have...
Our production database server has 16GB of memory. It is running Windows 2003 Server Enterprise and SQL Server 2000 Enterprise. In the boot.ini we...
Is there a downside to having a large transaction log for a database aside from the disk space usage?
In SQL Server 2000 is there a way to grant execute on all stored procedures without needing to re-grant permissions each time a stored procedure is...
In our environment we have a database the houses a bunch of common tables (person, person name, person address, etc...). We then have several...
I recently rolled out new dev, test, qa, and prod database servers. When building them we applied SP4 to SQL Server. My question is what do you do...
We have SMS 2003 running on a SQL Server 2005 instance. We were thinking of applying SQL Server 2005 SP2 to the instance. Does anyone know if there...
We started getting the following error today on a server I just rolled out on Sunday. Autogrow of file 'CMN_PRD_Data' in database 'CMN_PRD'...
Separate names with a comma.
