Administering

• Topics

  Started by

  Posts

  Last post

• Logins with Log Shipping Server

  Hi all, Here I am facing one issue in Log Shipping server: I have configured the Log Shipping in my…

  trayalacheruvu

  6 replies

  11 years, 12 months ago

  By: DBA-640728

• Rename Excel Worksheet Tabs

  Does anyone know a way to rename the worksheet tabs on an excel spreadsheet using either SSRS or SS…

  brickpack

  7 replies

  11 years, 12 months ago

  By: yllanes

• Insert and indexes

  Good morning INSERT query is suddenly taking too long to run which used to run under 30 minutes is …

  SqlSavy

  7 replies

  11 years, 12 months ago

  By: Bhuvnesh

• Partition Existing Table with Primary Key Clustered Index

  I have a table called Sales with primary key clustered index on SalesDate and OrderNumber. I would …

  khy shy

  1 replies

  12 years ago

  By: Gail Shaw

• Why do i see writes in profiler trace when my query is only a select?

  I just noticed that i see some writes under Writes column on sql profiler trace. These writes are p…

  curious_sqldba

  4 replies

  12 years ago

  By: curious_sqldba

• High READS and WRITES number in profiler

  Hello, When I see high numbers in READS and WRITES columns in Profiler, what does that mean? Ho…

  ramadesai108

  10 replies

  12 years ago

  By: curious_sqldba

• Update Statistics job failed

  I have a SQL Server 2005 server (32-bit, Standard edition and PS3) running on Windows Server 2003 I…

  Grace09

  1 replies

  12 years ago

  By: Dan.Humphries

• Locks - Blocked Processes

  Hi, We are using Spotlight for monitoring and we are getting Blocked processes alarms. I would like…

  Mani-584606

  10 replies

  12 years ago

  By: dazpoc

• Installing 64-bit SQL2005 Standard

  I'm new to SQL2005 64-bit (and to the W2K3 64-bit O/S too). I'm trying something new! Does the 32-b…

  rew-370421

  10 replies

  12 years ago

  By: Gail Shaw

• OS upgrade and SQL server install

  I would like to upgrade the OS of a SQL Server 2005 Standard installation. The OS is currently Wind…

  Chrissy321

  1 replies

  12 years ago

  By: Chrissy321

• Create Views issue

  The user account has dbo permissions on the database but couldnt create the views not sure what is …

  psred

  5 replies

  12 years ago

  By: Steve Jones - SSC Editor

• Among other errors: SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection.

  My SQL Server instance has crashed 2ce in the last week now with the same symptoms. My monitoring s…

  Kenneth.Fisher

  1 replies

  12 years ago

  By: michaelberry67

• Getting an error "Exception of type 'System.OutOfMemoryException' was thrown." during stored procedure execution

  Hi I am running a stored procedure that have lacs of select command but query is showing this error…

  dsachu

  42 replies

  12 years ago

  By: pradeep.mohan

• How do i get 'Last Execute' time NOT 'Last Run time'

  I know i can get the last run time from job history, in this case the job history is deleted. Howev…

  curious_sqldba

  2 replies

  12 years ago

  By: SQLDCH

• Interpret Output of TSQL_Replay trace

  Can someone please tell me which column provides the actual execution timings based on the output f…

  curious_sqldba

  3 replies

  12 years ago

  By: curious_sqldba