SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Open Transactions and CPU usage

  Hello, Can anyone tell me if SQL has a transaction that is open but is in a sleep status, if that S…

  rodmeans

  5 replies

  14 years ago

  By: Gail Shaw

• Database Blocks:table is in LOCK status as sp_cursorclose not getting processed

  HI All, I am facing a weird issue ,during the processing of the certain tasks from Application,some…

  rkumar590

  3 replies

  14 years ago

  By: Grant Fritchey

• View Connections in DMV instead of Profiler

  Hi all, Im looking the isolation level of a server and opened profiler on a users connection which…

  Staggerlee

  2 replies

  14 years ago

  By: Staggerlee

• Select Data Using Pivot methd

  Hello i have one table called deposit CREATE TABLE [dbo].[deposit]( [NominalID] [int] NULL, [date…

  dilip.aim11

  1 replies

  14 years ago

  By: dilip.aim11

• Remove MSDTC from Cluster

  Hi - I recently uninstalled a SQL cluster, however I am left with an issue with MSDTC. I am trying…

  Kwisatz78

  8 replies

  14 years ago

  By: Kwisatz78

• Backward Compatibility

  Hi all I know that SQL Server is backward compatible - I can restore a 2005 Database into a 2008 in…

  SQLSACT

  8 replies

  14 years ago

  By: peerhansen

• Inserting While Selecting a SQL Table

  I'm very new to SQL Server and am programming a front end to a database using c++ and ADO. I've no…

  tobinare

  12 replies

  14 years ago

  By: SGT_squeequal

• SSRS and Stored Procedure

  Hello, I'm building a report in SSRS. I have many datasets in the report. The datasets are built ba…

  Beginner2012

  2 replies

  14 years ago

  By: Koen Verbeeck

• Best way to quickly discern table relationships?

  Hey all, I received a database containing user data from a firm, and my job is to locate and extrac…

  SQLUserC

  16 replies

  14 years ago

  By: RBarryYoung

• OpenRowSet saves image in which format?

  Hi, Thanks for coming here and reading my question. I have one table called TRN_Image and here I ha…

  cpatel

  6 replies

  14 years ago

  By: cpatel

• Setting in SQL server 2008 R2 to Force optimize to consider all possible plans

  Usually optimizer try to get the best plan in minimal time and thus might not consider all the poss…

  Gullimeel

  1 replies

  14 years ago

  By: Tim.Messar

• Does varchar(8000) really store 8000 characters?

  I set one column as varchar(8000) but user still complain that some input was cut off. Does varchar…

  adonetok

  6 replies

  14 years ago

  By: Paul White

• Need to understand the logic for T-SQL Query

  Can Anyone explain the logic to behind to get the first day of the month SELECT dateadd(MM,datediff…

  Jay Pete

  4 replies

  14 years ago

  By: Sean Lange

• package looging for SSIS Package

  Hi All, I have SSIS package which loads the millions of data everyday.SSIS package has Flatfile Sou…

  Jay Pete

  3 replies

  14 years ago

  By: Jay Pete

• Short cut for migrating SSIS packages?

  Hi All, We have to create some standard DBA maintenance plans everytime a new SQL server is install…

  MI_DBA

  1 replies

  14 years ago

  By: kiro72