SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Problems creating SQL Agent Job from within a stored procedure

  Hi, I've been battling with this for some time now and can't see what I'm missing. I have a windows…

  Stuart Pearson

  1 replies

  12 years ago

  By: Stuart Pearson

• Check for null or empty values and return 0

  Hi, I am using the below query to calculate column values. But I need to return zero when a column …

  vigneshkumart50

  3 replies

  12 years ago

  By: Keith Tate

• Execute STored procedure from Execute SQL Task in SSIS

  Hi, I got and Stored procedure whihc will be doing some Deletes, Inserts and Updates with in it int…

  tripri

  5 replies

  12 years ago

  By: jayant.m.1

• Deadlocks - SQL Server Monitors for Deadlocks Right?

  Hi, Can anyone please explain this to me; SQL Server has as dedicated thread that monitors for dead…

  ReamerXXVI

  4 replies

  12 years ago

  By: Gail Shaw

• sp performance

  Hi there, My test and live server are alike in terms of configuration(CPU,memory etc).Databases are…

  SqlSavy

  15 replies

  12 years ago

  By: Grant Fritchey

• Prevent automatc startup of SQL server on Cluster after windows reboot

  Guys, I need to disable automatic startup of SQL Server on a 2 node active/passive cluster after Wi…

  SQL!$@w$0ME

  4 replies

  12 years ago

  By: SQL!$@w$0ME

• Merge Partitions in SQL Server 2008 R2

  Hi, We have the following scenario on our company. There's a table which keeps 60 days of data and …

  rafa.aborges

  5 replies

  12 years ago

  By: MysteryJimbo

• DBCC Reindex

  If i try to DBCC DBREINDEX (Table_name, '', 70); i am getting the error msg. how to shrink table si…

  yuvipoy

  15 replies

  12 years ago

  By: pmadhavapeddi22

• Best way to store top 1 record of a table to reduce lookup

  Using a trigger we want to send out a notification when the top 1 record changes. Instead of runnin…

  jbonavita

  10 replies

  12 years ago

  By: Gail Shaw

• Import wizard doesn't like importing into Geography column - SQL Server 2008 R2

  Hello, I have been given a CSV file which consist of about 10 rows (nothing major), One of the col…

  .Netter

  3 replies

  12 years ago

  By: mickyT

• query timed out expired

  while connceting server i am getting query timed out expired , how to slove this

  ramyours2003

  5 replies

  12 years ago

  By: SQLBuddy123

• Checking a SELECT statement when debugging a Stored Proc

  I have a stored proc that says: WHILE EXISTS(SELECT * FROM @SystemComponentTbl) BEGIN It skips…

  Jacob Pressures

  12 replies

  12 years ago

  By: Jacob Pressures

• WHILE EXISTS statement does not complete whereas inside condition completes instantaneously

  I have the following bizarre situation and was hoping someone could help me figure it out. The foll…

  Marios Philippopoulos

  5 replies

  12 years ago

  By: nastonefasto

• Primary Keys: 1 vs multiple

  I'm on a development team that inherited a project from an office that was closed. I'm not a DBA bu…

  joepacelli

  8 replies

  12 years ago

  By: humbleDBA

• Partitioned table and data compression

  I have a partitioned table with six partitions, with a partition function defined for an integer va…

  N_Muller

  2 replies

  12 years ago

  By: N_Muller