SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• XML Vs Non-XML

  I am using SQL Server 2008 R2. While using XML data type and  XQuery slow (50 Times slow) compare …

  IT researcher

  3 replies

  1 day, 17 hours ago

  By: Jeff Moden

• sql Database (MDF) repair Best Tools

  hi MDF file corrupted Best Repair Tools or Software ? What is your suggestion

  TeknikServis27

  7 replies

  1 week, 1 day ago

  By: Cigatisol

• SQL service account is sysamdin or not?

  A question I have not got a clear answer: When installing SQL server 2008 or 2008 r2, we choose to …

  sqlfriend

  15 replies

  2 weeks ago

  By: Thomas Franz

• Store Decimal values without Trailing Zeros

  I am using SQL Server 2008 R2 version. Is there any method to store decimal value in SQL without ex…

  IT researcher

  3 replies

  1 month, 1 week ago

  By: Jeff Moden

• Identifying SQL Agent Job Name based on the job id.

  I'm trying to figure out which Job is running, based on this the following name. Where can I find t…

  DVSQL

  8 replies

  1 month, 2 weeks ago

  By: Robert vd Berg

• sys.dm_os_performance_counters Resource Pool Stats returns zero

  I am using SqlServer 2008 R2 Express edition. When i execute below query i will get all 0 . select …

  IT researcher

  6 replies

  1 month, 2 weeks ago

  By: Grant Fritchey

• Need Create View Script for all tables

  I manage a SQL 2008 R2 Production environment for an application. We have a new requirement to crea…

  S_DBA

  52 replies

  2 months ago

  By: romain.ferraton 82381

• Recover from error log scan number(93799:2191:1) database not valid

  Hi Everybody, Please how do i recover from this error while trying to attach my database: Could not…

  timotech

  9 replies

  2 months ago

  By: prettsons

• SharePoint list source/destination adapter for SSIS- SQL Server 2008 R2

  Hi, I used to be able to download the SharePoint list adapters from Codeplex to connect to SharePoi…

  rachefur

  1 replies

  2 months, 1 week ago

  By: fabioms

• Select query is slow for Non clustered index

  I am using SQL Server 2008 R2. Select query is slow when non cluster index is used in the table  c…

  IT researcher

  1 replies

  2 months, 2 weeks ago

  By: Erland Sommarskog

• Replication reinitialize error

  I am getting an error 'Cannot reinitialize subscriptions of non-immediate_sync publications; Micros…

  kcsujith

  1 replies

  2 months, 4 weeks ago

  By: kcsujith

• create procedure which contains special caracters from .sql file with sql powershell

  Hello, I have a .sql file which is actualy the body of a stored procedure. The procedure containts …

  manole_i

  5 replies

  3 months ago

  By: JediSQL

• policy based management for the STIGS

  Howdy, I am working with complex conditions for policy based management in SQL Server 2008. I haven…

  Donatello

  9 replies

  3 months, 1 week ago

  By: Tony

• Stuff xml path query

  Hello guys, i have table like yellow area, i want result like green area: I used: SELECT * FROM (…

  mrsiro

  26 replies

  3 months, 1 week ago

  By: Erland Sommarskog

• Error for updating Extended Property

  The following Error occurs while updating extended property of a table in SQL  Server 2008 R2. Wha…

  IT researcher

  7 replies

  3 months, 2 weeks ago

  By: Erland Sommarskog