Wishing all of you a splendid 2007. Thanks to all of your contributions... It sure is nice not just to have questions answered but also read the answers to questions posted by others. And a special thank you to those answering our questions. Sure wouldn't be fun resolving SQL issues if not ...more >>

Is there any update for the details in the output for DBCC memorystatus for 2005 ? ...more >>

I am having problem w/ a Left Join when trying to create a SQL view. I am trying to get all the records from the left table plus the data from the right table where it has matching rows. Following is my SQL stmt I am using to create the view. I am getting data, but only data where the two t...more >>

I am getting this message in the event log "IO Completion Listener (0xe0c) Worker 0x00000000040601C0 appears to be non-yielding on Node 0. Approx CPU Used: kernel 0 ms, user 0 ms, Interval: 15016." Soon after this, the sql server stops. I am using SQL Server 2005 service pack 1 This has ...more >>

I want to know how much of my buffer pool is being used for data and how much is consumed for procedure cache? Is there a way I can find out? ...more >>

Whats the difference between sessions and connection in 2005 ? ...more >>

Hello, 1. My hosting provider hosts ~500 databases on the server where my DB resides. To open my database I use SQL Server 2000 Enterprise Manager. While server connection timeout is short enough (about 1-2 seconds), when I click "Databases" folder in server hierarchy, trying to enlist all...more >>

I installed SQL server 2005 on a Windows 2003 Server everything went well. I also installed sp1 everything went well. I decided to add a second instance in the process I received two warnings: 1 default installation path permission requirement 2. edition change check>to change an existing inst...more >>

Hi guys, I have two websites written in .NET that use MSDE and that I'm trying to migrate over to SQL Sever 2005 Express Edition. Both sites have a similar workload (i.e. very small). I wanted to compare the performance of the two so I kept one site in MSDE and the other I converted to 2005...more >>

I am using SQL Server 2000 and need to run the maintenance plan wizard, but the "Database Maintenance Planner" option in the Tools menu is disabled (greyed out) no matter which node I click on. Google searches have turned up nothing. Help! ...more >>

I would like to grab a handful of DMVs and Catalog views one should get familiar with while working on SQL 2005 as a DBA. For eg: in SQL 2000, I would look at sp_who2, sysprocesses,dbcc inputbuffer,sp_lock,sysobjects,sp_dboption,etc. Just would like to get a comparison of the SQL 2000 objec...more >>

Hi there, How do I get a list of the column names in my SQL tables? Preferable a list that can be exported to Excel or Word. Thanks! Yvette ...more >>

I have a client that is continually getting this error message: Could not continue scan with NOLOCK due to data movement Intially they were not at SP4 of SQL Server 2000, so per this Microsoft Document they patched the server http://support.microsoft.com/default.aspx/kb/815008. Even after...more >>

I believe that SQL 2000 64 bit on x64 AMD Procs are not truly 64 bit, but some WoW and that true 64 bit is only suppoerted on IA64 for SQL 2000. Please let me know if this is true and if so, what would be the difference in the x64 vs IA64 versions as it relates to SQL Server. What pros and co...more >>

I ran a sql script which has a cursor to process about 5,000 rows on the test server as a test run before running it on the production server. It took 20 minutes on the test server, but over 7 hours on the production server. The production server is dual with a lot more RAM, etc. Is the p...more >>

Why did MS use the trem "Truncate transaction log" to refer to the process of making the log space with committed and backed up transactions in the transaction log reusable? I keep dealing with people who think the term means the same as shrinkfile in that the physical file becomes smaller ...more >>

If I schedule transaction log backups on a file every half hour (using a database maintenance plan), and during the middle of the night I know no one is using the database, why are the backup files large? Depending on the database, I might get a succession of files all the same size of perha...more >>

Since indexed views aren't going to work for me, I'm working on revamping a large, ugly query that hits a large, ugly database. The database stores inventory. Some items in inventory are single items (e.g. a calendar), while others are grouped (e.g. a shirt with several color/size options). ...more >>

When could I expect SP2 for SQL Server 2005 to be released (not beta or release candidates)? An approximate date would do, eg Jan, Feb... I want to run SQL Server 2005 Developer Edition on Windows Vista and I believe it's only possible when SP2 is released. Thanks. ...more >>

Hi, I have a SP the runs fine during a period of time, but after a database back up, it stops working until it is recompiled again. What would break this? The SP does use a function that creates a tempDB table with about 8000 rows. Thanks. ...more >>

Does SQL Server have a command line program that can dump a whole database into sql insert statements. I would like to reload the whole database on another computer. -- Arne Garvander (I program VB.Net for fun and C# to get paid.)...more >>

I've got a web application that does queries against a very large product database (SQL Server 2000). The data that needs to be returned is such that the query is HUGE, and very expensive. Thus far, I've had great success by caching that big query (returning all rows) in my web application se...more >>

We have a production database that is being used by at least 20 different applications. Some of the tables need to be modified (column added). Does anybody have a good way or best method of changing table schemas, objects, etc. without interrupting or at least minimizing the impact on the curr...more >>

Hi all, I have the following situation: SQL 2000 server 2 Databases "ARDC", "PMM" Users log into and use PMM. Stored procedures accessed on PMM by users, Select data in ARDC, such as: SELECT P.COL1, P.COL2, A.COL5 FROM TAPLE1 P, ARDC..TABLE1 A As dbo, ...more >>

We have an OLTP database handling our business production operations. Our reporting team wants to extract from the OLTP db every 15 min, but that will hammer the OLTP db I/O-wise, breaking the system. The reporting team wants a copy of the OLTP system to do their extractions. The copy sho...more >>

We regularly load data into hundreds of tables in a reporting database. I know that many of the tables were needed years ago for short-term projects, and are no longer used. I'm trying to find a way to identify which tables are never accessed by users, so that we can stop those loads and drop ...more >>

SQL Server 2005 Someone here attempted to update about 3000 rows in a table that is in replication (on the publisher side). We are using push replication. The rows were updated successfully on the publisher table, but for some reason, it serioulsy locked up the replicated table on the subscr...more >>

Hi all I want to use SQL Server 2005 Express for my application The concern I have though is user installation. Is is possible to do a silent install as the installation process for SQL server would throw a lot of my clients into panic ? Also is it possible again to do a silent install ...more >>

Hi, we have a new server, a 4 dual core cpu em64T machine. It has 20 GB of RAM. We need to install sql 2000 on it. We discovered that we must use SQL 2000 32 bits edition because the 64 bits only works at the ia64 processor arquitecture. We decided to install Windows 2003 64 edition so i...more >>

On the General tab of a database properties screen there are two fields: Size and Space Available. Is there a way to access the two fields programmatically? This would be an easy way to keep track of when the database needs to be grown. Thanks, ...more >>

I've read the BOL about setting trace flags: DBCC TRACEON DBCC TRACEOFF DBCC TRACESTATUS Also - Via the startup parameters of the services applet '-T1807' Via the server properties sheet startup parameters '-T1807' Via the command line The problem that I am having is the flag doesn't persi...more >>

Hi all. Is there an API/table/view/stored procedure in SQL Server that enables collections of a variety of statistics per connection in the database ? I'm familiar with the master..sysprocesses table, but there is only 4 kind of statistics in this table, and I'm looking for more information a...more >>

Hi Friends, When the following query is run, its performing Clustered Index Scan on 'EditHistory' Table though EH.Id is its PRIMARY Key. Its taking a lot of time. Cud u please resolve this? SELECT EditDate,ObjectId FROM dbo.EditHistory EH (NOLOCK) INNER JOIN dbo.EditHistoryIntDetail EI(...more >>

Hi, How do we find the load on the SQL server database. even i am not asking in the right mannar but i will can explain my problem then u suggest me the right way to clear my problem. i have written my code in C++,i am using multi threading and my database is SQL Server. i closed the conn...more >>

From what I've read, there seems to be 4 ways to ensure that if your main SQL Server 2005 machine dies, that you can have a backup machine up-and-running relatively quickly. 1. Backup the databases on the master server and restore them to the backup server on a regular basis using a mainten...more >>

I have a SQL server 2005 box with 8 GB physical memory. The windows task manager reports 7.4G PF Usage. Is this accurate?...more >>

Is it possible to use AWE and /3gb option and cause the OS to become constrained? Is so what key OS services are critical and which ones should be stopped? thank -John...more >>

How can I get the listing of sp_who (or any other procedure)?...more >>

Dear all, I need some help from all my Transact SQL Guru friends out there.. Here is the scenario in its most simplified form.. .. I have two tables.. A(Lookup table) and B(Transaction Table) TableA Fields EmployeeLocationID EmployeeLocation (This could have values say "B","BO",...more >>

Does anybody know of a tool or script that will tell the difference between two tables including objects such as indexes?...more >>

Hello... I am basically a SQL newbie, but I do have this problem: I have several SQL 2005 Enterprise installations, each running a number of databases, which seem to work without problems... but one of my developers has asked me to figure out why they cannot 'see' the SQL Agent from within ...more >>

Hello! is there a possibility to get all transactions between two dates out of transaction log, an then inject this data into a new database? i need the data from 01.09.2006 to 24.12.2006. the last full backup - witch is not available - was before this time, so all changes must be in the tr...more >>

If so, is the role different based on the platform? More stress/ hours in one than the other? Is the work a lot different between the two? Which did you enjoy more? Why? TIA, ChrisR ...more >>

I was exploring ways of archiving old data in our production environment whilst maintaining it's availability... ...the current data takes 90% of the queries, but grows very large and puts pressure on the disks... ...I wanted to explore using a "sliding window" on a partitioned view across a f...more >>

How can I write a function that accepts a data as a parameter and if the date is 1. Last Monday in May or 2. First Monday in September or 3. 4th Tuesday in November returns true otherwise returns false. ...more >>

Hi all, I have a problem with a SQL Server database throwing an error I have never seen before, and cannot remember ever seeing anywhere else either (even a google search doesn't throw anything up). Here's the exact text... 37000 [Microsoft][ODBC SQL Server Driver][SQL Server]Storage Alloc...more >>

I know there have been changes to certain execution plans in 2005.. For eg: , there is no more bookmark loolup thats displayed in 2005, but is represented as a nested loop join.. All i want to know is that if i run my query from SQL 2000 QA connected to SQL 2005 instance, will it show the n...more >>

I know the executives at MS have promised for a 2 year release moving forward and if thats true, we should be having one in the coming year. But I dont see any sight of the same happening. Can someone confirm ? I believe the code name is Katmai. ...more >>

Why doesnt MS implement a compression algorithm within their SQL Backups ? It seems to be simple, I guess . That way, we dont have to get some 3rd party products like LiteSpeed,etc that may have memory issues,etc. Is MS not implementing this just because of contractual obligations ? Just cu...more >>

I just glanced at the logical processing flow of SQL Statements in Itziks TSQL Querying Book and wanted to know if this applies to SQL of any RDBMS such as Oracle, DB2,Sybase,MySQL,etc or is it strictly for SQL Server ? Also what are the different ANSI Standards. I've heard of 92,99,2003..but...more >>