Administering

• Topics

  Started by

  Posts

  Last post

• What covering index can i create for this query?

  Most of the cost is around "Cov" table. I need to create a covering index because it is doing an c…

  curious_sqldba

  2 replies

  14 years, 10 months ago

  By: curious_sqldba

• are tables cached in the same location as procedure cache?

  I have a sproc in which there are bunch of select statements...now if i just run the select stateme…

  curious_sqldba

  3 replies

  14 years, 10 months ago

  By: Gail Shaw

• Urgent: Help required with mimatched Service Packs on SQL2005 Cluster

  All, We have a production cluster (active/passive) where the active node had a hardware failure and…

  Steve Newton

  1 replies

  14 years, 10 months ago

  By: Steve Newton

• Urgent: how do I run a job under a specific group account

  Hello, I have a job which is working fine under my personal window domain account, now I need to l…

  halifaxdal

  3 replies

  14 years, 10 months ago

  By: halifaxdal

• SQL Server 2005 List of all tables used in a stored procedure

  Never mind. I had too much turkey over Thanksgiving. Since the store procedures are all in the ma…

  Dan Hangen

  1 replies

  14 years, 10 months ago

  By: cpressoirjr@yahoo.com

• Update Statistics - These three options are ON?

  I have a huge database with the below three options ON. I am not sure if i should be having all the…

  curious_sqldba

  7 replies

  14 years, 10 months ago

  By: curious_sqldba

• Restore database error.

  Hi, We have a develpment server just same as the production server. We take backups of all the d…

  Skybvi

  34 replies

  14 years, 10 months ago

  By: Skybvi

• client side em for sql server2008

  how to access EM in client system for sqlserver2008..?

  Coolroof

  5 replies

  14 years, 10 months ago

  By: Lowell

• ACtive-ACtive Clustering SQL server 2005

  Hi if any one knows ACtive-ACtive Clustering SQL server 2005 disadvantages. Please help me out.

  viswanath09

  18 replies

  14 years, 10 months ago

  By: TheSQLGuru

• SQL Cluster

  i have active - passive cluster with sql 2000 and there is an installation of OS going to happen in…

  premkuttan

  2 replies

  14 years, 10 months ago

  By: crazy4sql

• sql restarted itself

  I have SQL Server sp3 2 node cluster that restarted itself instead of failing over twice in couple …

  sqlstar2011

  3 replies

  14 years, 10 months ago

  By: atulkapoor20-965628

• Moving Instance from Drive to Drive on same server

  I did some searching but all I came up with was restoring to a new server and such... Anyway, I hav…

  Vertigo44

  8 replies

  14 years, 10 months ago

  By: Perry Whittle

• SQL Server datetime

  SQL Server only has datetime. Can just the date without time be stored in the datetime ? Please l…

  Krasavita

  3 replies

  14 years, 10 months ago

  By: GSquared

• Database Mail setup

  is there a way to script out the setup and run the same on a differnt server. I have to create mail…

  Tara-1044200

  3 replies

  14 years, 10 months ago

  By: SQLRNNR

• convert string into smalldatetime

  Hi, I have strings like this: 20110531095841 is there any function to convert this string to date ,…

  river1

  3 replies

  14 years, 10 months ago

  By: Ron McCullough