SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• ALTER TABLE / ALTER COLUMN datatype I/O considerations / measurement

  All, I was wondering what considerations (if any) were there (along with mitigating operational pro…

  Jeremy Brown

  4 replies

  14 years, 8 months ago

  By: Jeremy Brown

• Adjusting Timezone

  I have a SQL 2000 in-house website reservation system and planning on migrating to SQL 2008 but the…

  studySQL

  2 replies

  14 years, 8 months ago

  By: studySQL

• Best way to identify application timeouts

  Every once in awhile our application is getting timeouts(not to be mistaken with deadlocks). I have…

  ericwenger1

  7 replies

  14 years, 8 months ago

  By: Ian Scarlett

• Load Excel into DB

  I am trying to load Excel file into DB. I have 64-bit SQL Server and 32-bit Excel. When I run SELE…

  Shurkadze

  1 replies

  14 years, 8 months ago

  By: Joie Andrew

• Help with slow access on one SP

  Hi all, I have a SP that when I run in SSMS it runs in less then a second. I can do this all day l…

  John Burris

  3 replies

  14 years, 8 months ago

  By: Lowell

• System Databases and DBPro........

  I have a database project I am trying to create. It references several objects in MSDB and one in …

  Angelindiego

  1 replies

  14 years, 8 months ago

  By: GSquared

• When does sql 2008 release "memory"?

  We run a monthly process that causes sql to use about 11GB of RAM. The remainder of the month the s…

  Barkingdog

  6 replies

  14 years, 8 months ago

  By: sam.alexander

• Dont see Transaction log shipping option under properties under database properties.... why?

  Hi, All Dont see "Transaction log shipping" option under properties under database properties.... w…

  harita

  9 replies

  14 years, 8 months ago

  By: harita

• CONCATENATE not working

  Hi, can someone please help me with this syntax, it is not working in sql server LEFT(TRIM(CONCATEN…

  Krasavita

  13 replies

  14 years, 8 months ago

  By: GSquared

• View vs Ad-hoc T-SQL

  Hello, I have a view that basically joins two tables of > 1million rows. Example Only: create VI…

  uncle_boris

  14 replies

  14 years, 8 months ago

  By: Gail Shaw

• error '3146' when importing file using access as front end into SQL Server

  Hi We have access serving as front end connecting to SQL server. Our SQL Server was upgraded from …

  samdp0817

  1 replies

  14 years, 8 months ago

  By: Sean Lange

• Visual Studio deploy of views using OPENQUERY via linked server with sqlcmdvar reference causing syntax error.

  When building a Visual Studio 2010 database project, having views that use OPENQUERY (instead of 4-…

  Drikus Roux

  2 replies

  14 years, 8 months ago

  By: Drikus Roux

• backup files delete - script

  Hi, I need to clean backups and the condition is to delete all bak files in the folder but keeping …

  ALIF-662928

  4 replies

  14 years, 8 months ago

  By: ALIF-662928

• using local variables in place of passed parameter

  I have run across several scenarios where my Stored Procedures, with a parameter, take an abnormal …

  jch50a

  3 replies

  14 years, 8 months ago

  By: jch50a

• SSRS - How to eliminate blank page?

  I have requirment to add 3 sub reports to existing report Needs to make visible true / false based…

  visual.prabu

  1 replies

  14 years, 8 months ago

  By: Perry Whittle