I have more than 100 SQL Server jobs scheduled to run simultaneously and continuosly. Several of these jobs are not running and with the status...
Hi all, I have 2 identical databases in a server. The following query on these databases giving the output in different sort order : select...
Hi, I'm getting the following error while trying to run the SQLH2 reports from Report Manager. Query execution failed for data set 'serverID'....
Hi, I've restored a database from backup, with STANDBY option. Now, when I'm trying to apply further Transaction logs to this database, the restore...
Red-Gate is giving away a free ebook of Best of SQLServerCentral.com Vol1. http://www.red-gate.com/dynamic/downloadsqlsvrcentral.aspx
What kind of SQL Server licensing do I need for a standby server ? This server is not accessed by users and will be synchronizing databases from...
Is anyone playing around with beta 2 ? What is this 'sys' user. Most of the system SPs and System views are being owned by a user called 'sys'...
I was playing around with Best Practices Analyzer on one of my test servers. It says enabling Priority Boost is 'Non Compliance'. I think it should...
As everybody here knows, a DBCC DBREINDEX on a database creates lot of empty space in the database. Now I'm trying to reclaim this disk space by...
Hi, I was playing around with the 'rowmodctr' column in sysindexes table. I tried updating different columns in a table, but everytime the rowmodctr...
After enabling AWE on my SQL Server (Enterprise Edition), the memory used by SQL Server is showing a very low value (around 70 KB), under Task...
Is it alright to move system databases from Standard edition to Enterprise edition ? I'm planning to move all my databases from a standard edition...
Can anyone suggest me a good source control tool/utility for SQL code ? I know most of the people here use VSS for this. But, I'm looking for a...
Hi, I have a strange problem happening in our production. Certain stored procedure calls through the application are occassionally taking abnormally...
I have a table that I'm planning to move from one database (DB1) to another database (DB2). Both databases are on the same SQL server. Can there be...
Hi,<br /><br />Did anyone heard about or attended the advanced SQL courses offered by SolidQuality Learning.com ? I just want some feed back and some...
I have a table with two smalldatetime columns (date1, date2). I want to see if there is any date in these columns with a time value other than...
I have this strange performance problem in my production that I want to get some inputs from you guys. Once in a while, our users start complaining...
Microsoft released some more information about 'Yukon' today. http://www.microsoft.com/sql/yukon/productinfo/top30features.asp
Hi, Is there any way to copy the execution plan (generated by Query Analyzer) to clip board or to save it as a file ?
Separate names with a comma.
