SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• limiting columns in result set for performance and count(*) optimization

  I'm assuming SQL Server is optimized for count(*) and a using a specific indexed column doesn't mak…

  sqlguy-736318

  3 replies

  14 years, 5 months ago

  By: Gail Shaw

• Corrupted Execution Plan

  I have a stored procedure using VARCHAR(MAX) in one of the parameters. The stored procedure is cal…

  Loner

  22 replies

  14 years, 5 months ago

  By: Alexander Suprun

• A recursive function for the sum of "n" number of a series

  .Una funcion recursiva para la suma de los "n" primeros numeros de la serie A=1+2+3+4+...+n

  champions

  6 replies

  14 years, 5 months ago

  By: Jeff Moden

• General question on views vs stored procedures

  Let me preface this by saying I have NEVER written a view, my system has thousands of stored proced…

  andegre

  3 replies

  14 years, 5 months ago

  By: Jeff Moden

• Export To SAS

  SAS ... SAS... , not ssas ... Need to find out if direct export to SAS from SQL is possible, it se…

  dancewav

  9 replies

  14 years, 5 months ago

  By: John_Hill

• TCP Provider: The specified network name is no longer available.

  Hi All TCP Provider: The specified network name is no longer available. [SQLSTATE 08S01] (Error 64)…

  trarunprasanna

  1 replies

  14 years, 5 months ago

  By: Jack Corbett

• Upgrading to SQL2008 from 2005

  I had some functions that were not recognized in SQL2008 post upgrade. Compatibility was set to 90 …

  Candls

  2 replies

  14 years, 5 months ago

  By: Candls

• Asymmetric Key with Certificate

  I have a requirement to encrypt data using RSA, and to be able to make the public key available. I …

  katjacurtis

  8 replies

  14 years, 5 months ago

  By: Nadrek

• funcion recursiva para la suma de n numeros de una serie

  .

  champions

  2 replies

  14 years, 5 months ago

  By: GSquared

• Import CSV file to temp table

  There are about 100 CSV files in a file server need to import to temp tables for further processing…

  adonetok

  1 replies

  14 years, 5 months ago

  By: GSquared

• "Print" inside stored procedure- Performance

  Hi All, In some stored procs that use dynamic query mostly I have Print @sql @sql is the variabl…

  daniarchitect

  3 replies

  14 years, 5 months ago

  By: Elliott Whitlow

• Stored procedure not choosing the correct execution plan

  We have a stored procedure that runs just fine in SSMS (1 second), but when it's run via ODBC, it r…

  andegre

  5 replies

  14 years, 5 months ago

  By: andegre

• Log shipping issue

  Hi, I am trying to setup logshipping between two 2008 R2 sql server databases on two different serv…

  sql_novice_2007

  9 replies

  14 years, 5 months ago

  By: MyDoggieJessie

• HELP, what is "SQLTRACE LOCK"

  Quest Performance Analysis says this is taking up 90% of our production resources right now. Our sy…

  andegre

  11 replies

  14 years, 5 months ago

  By: andegre

• How to audit insert/update in a specific table

  Hi, I am trying to figure a way to audit all update/insert done on specific table. When I use Prof…

  Rem70Rem

  8 replies

  14 years, 5 months ago

  By: Lowell