SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Deadlock on update command

  I have the following dead lock happening quite frequently at 3-4 times a day. The deadlock seems t…

  bugg

  29 replies

  13 years ago

  By: Michael Valentine Jones

• Why such a delay in the commit?

  I have a scheduled job (.Net, WinOS Task Scheduler) which completes shortly after it's called but t…

  pbarbee

  3 replies

  13 years ago

  By: Jason Wolfkill

• Parent-Child But Not All Have Children...?

  Here's a tricky one: I have to show values for each of our customers. Data comes from a table somet…

  brian.battles

  3 replies

  13 years ago

  By: brian.battles

• Comma separated lists

  Hi all I've got a couple of queries that use quite large comma separated lists in the WHERE clauses…

  richardmgreen1

  6 replies

  13 years ago

  By: Sean Lange

• Sandbox environment for customers

  I am looking for ideas on how to solve few problems we have with our customers creating sandbox env…

  laubenth

  1 replies

  13 years ago

  By: x

• Moving data from one mdf to multiple ndf files

  I have a database with one 110g mdf file. I would like to stripe the I/O across five 25g files and …

  smitty-1088185

  8 replies

  13 years ago

  By: Gail Shaw

• Naming Multi-Line Table-Valued Function Default Constraints

  I want to be able to name the default constraints that I place on the table returned from a multi-l…

  BurikkuDeibu

  10 replies

  13 years ago

  By: Lynn Pettis

• SQL disk config

  Hello - I need to approve a SQL disk configuration - I know it is best to put data, logs and tempdb…

  NJDave

  2 replies

  13 years ago

  By: McSQL

• Strange datetime conversion issue

  I have been using a query that joins several raw tables (nvarchar datatypes), has several conversio…

  bochambers

  7 replies

  13 years ago

  By: Lynn Pettis

• how i can store marathi font in sql server

  I am going to design a application having front end with VB6.0 and Back end with SQL SERVER in. And…

  gamit124

  3 replies

  13 years ago

  By: Lowell

• Warning message for user having no db_owner permission but having full permission for the table

  I am accessing my sql server 2008 r2 express server using SSMS. I have about 5 logins. For a partic…

  IT researcher

  3 replies

  13 years ago

  By: John Mitchell-245523

• Trace Flag 8048, 8015, or SUMA?

  Hola! Recently included SQL Server startup Trace Flag 8048 to resolve a serious spinlock contenti…

  sql_handle

  6 replies

  13 years ago

  By: sql_handle

• need help in creating a procedure which uses cursor and variables

  have situation where i need to create a procedure that uses another table data and fetches each tab…

  sravan.here

  2 replies

  13 years ago

  By: ChrisM@Work

• Deadlock

  One of the system in my company was not available on the 9th Apr. As the application team in my com…

  fatinfzi

  1 replies

  13 years ago

  By: Gail Shaw

• Restoring file group error

  I have created the file group for my database.First i took backup of individual file group(mdf and…

  IT researcher

  11 replies

  13 years ago

  By: Gail Shaw