Search Results | SQL Server Performance Forums

Upgrading 32 bit to 64 bit - OS and SQL2008

Thread by: Moonwalker2000, Aug 1, 2012, 1 replies, in forum: SQL Server 2008 General DBA Questions

Hi there, What are the options/ways I can carry out the above "Upgrading 32 bit to 64 bit - OS and SQL2008". I am in a short term contract for a new...

Query the distributer DB

Thread by: Moonwalker2000, Jul 29, 2011, 1 replies, in forum: SQL Server 2005 Replication

Hi there, Are there any queries for looking into the distributer database to find out it's content. I'm getting 1-2 million transactions on two...

Cursor to rebuild indexes not working in a SP stored in master

Thread by: Moonwalker2000, Jan 14, 2011, 7 replies, in forum: SQL Server 2008 General Developer Questions

Hi there, I've created the following stored proc (was named sp_) in master to run a curser to rebuild indexes in any databases. But when I use a...

Calculate time between two dates in hours:minutes:seconds.

Thread by: Moonwalker2000, Jul 31, 2008, 2 replies, in forum: SQL Server 2005 General Developer Questions

Trying to use datediff drove me nuts and is ok of you have two dates from the same day. But try calculating the time for an index build for example...

Query 2 tables indvidually then in a union all view shows timings and execution plan.

Thread by: Moonwalker2000, Oct 15, 2007, 17 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

I query: first table: comes back in 6 seconds with 17K rows in results set Second table: comes back in < 1 second with 0 rows in results set. Both...

Spid hung on SQL2005

Thread by: Moonwalker2000, Mar 13, 2007, 6 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hello, Yesterday I ran a sp_who2 and viewed a job running with multiple spids each with 0 DiskIO and low CPUTime. This sat like this for hours as we...

LiteSpeed Backup and restore using filegoups

Thread by: Moonwalker2000, Oct 19, 2006, 16 replies, in forum: Third Party Tools

Is anybody here using LiteSpeed able to successfully backup and restore filegroups from a SQL database using LiteSpeed? If so, how is it working for...

LiteSpeed and filegroup backup estore

Thread by: Moonwalker2000, Feb 14, 2006, 6 replies, in forum: General DBA Questions

Hello, I'm having trouble restoring a database onto another set of disks for a Perf evaluation. Anybody have working examples of the restore code I...

shrinkfile progress

Thread by: Moonwalker2000, Mar 4, 2005, 2 replies, in forum: General DBA Questions

Is there any way I can see the progress of a shrinkfile operation that I'm running? I'm shrinking a very large file from which I've removed a lot of...

Trying to concatenate a string variable

Thread by: Moonwalker2000, Feb 18, 2005, 3 replies, in forum: General Developer Questions

Hello, I'm trying to bring back all the names from sysfiles sys table in a database to look like this:...

Multiple files in a file group & data spread

Thread by: Moonwalker2000, Jun 16, 2004, 5 replies, in forum: Performance Tuning for DBAs

Does anyone know how insrted data is spread across multiple files in one file group? Let#%92s say I have a table allocated to a filegroup with 4...

Logging/Auditing stored proc usage.

Thread by: Moonwalker2000, Mar 11, 2004, 1 replies, in forum: Performance Tuning for DBAs

I#%92m not sure is this the correct forum for this topic but: We are looking at implementing a way to log procedure calls in a database? If we are...

ANSI PADDING

Thread by: Moonwalker2000, Feb 16, 2004, 4 replies, in forum: General DBA Questions

Hello there,<br /> We've upgraded a database from SQL 6.5 to 2000 and the following is an example of a problem we're seeing after the upgrade:<br...

Update local data from data on a linked SQL Server

Thread by: Moonwalker2000, Feb 11, 2004, 4 replies, in forum: Performance Tuning for DBAs

Hello there, Below is a script I've written for a cursor to update a number of rows on a local SQL 2000 server with data from a remote linked SQL 6.5...