SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Dynamically construct SQL OPEN Query DB2 to Filter records in SQL Server Table

  I need to Dynamically construct SQL OPEN Query DB2 to Filter records in SQL Server Table. I have tr…

  Welsh Corgi

  4 replies

  14 years, 5 months ago

  By: Welsh Corgi

• Maintenance plan failing on index rebuild: deadlock victim

  During the step of the maintenance plan when the indexes are being rebuilt, the task fails. I get …

  SteveGravley

  10 replies

  14 years, 5 months ago

  By: SteveGravley

• Advendure db

  hi In my sql server 2008 i don't have adventure work db..but i want that db for testing so where c…

  sql Anand

  6 replies

  14 years, 5 months ago

  By: Devendrakumar

• Error: 18056, Severity: 20, State: 29

  Hi, we have a .net web application which experienced timeouts connecting to our SQL Server last nig…

  NickDBA

  6 replies

  14 years, 5 months ago

  By: Devendrakumar

• Does specifying COPY_ONLY make a difference?

  Hi I'm doing some backups to be restored to a different server as new DBs and it got me thinking...…

  derek.colley

  5 replies

  14 years, 5 months ago

  By: Gail Shaw

• How to concatenate fields and group them?

  Hi Guys, My first visit here, look like an impressive resource. I tried a search first but couldn't…

  cliff.gettings

  4 replies

  14 years, 5 months ago

  By: Cadavre

• SQL Replication - Archive of data problem

  Hi All, I want to ask your recommendations regarding a issue I am currently experiencing? I have a …

  Fox87

  2 replies

  14 years, 5 months ago

  By: Fox87

• Decrypt the data from the database table?

  Is there a way we can decrypt the data from a particular table in sql server 2008?

  Benki Chendu

  4 replies

  14 years, 5 months ago

  By: Grant Fritchey

• SELECT statement blocking UPDATE statement on a different table

  Hi All, Working on SQL Server 2008 R2. I've starting noticing a straight forward select statement (…

  Denesh Naidoo

  26 replies

  14 years, 5 months ago

  By: Ninja's_RGR'us

• When are partitioned indexes slower than regular indexes?

  I had someone tell me earlier on that on a partitioned table, for certain queries a non partitioned…

  winston Smith

  3 replies

  14 years, 5 months ago

  By: winston Smith

• Win7 vs WinServer2k8 for SQL installation

  Is there any performanace/functional difference for using Windows 7 64 or Windows Server 2008R2 for…

  steve 87491

  1 replies

  14 years, 5 months ago

  By: Ant-Green

• variables

  hi in my ssis i m having 2 variables called a & b by using row_count transformation i count th…

  sql Anand

  2 replies

  14 years, 5 months ago

  By: sql Anand

• Efficiency of a "Most Recent for Each" join

  I often perform reports which require joining the most recent of a many-to-one table joined back to…

  jeffkretz

  3 replies

  14 years, 5 months ago

  By: jeffkretz

• Cursor loop is not working. Only taking last value in parameter?

  I created stored proc so that user can select multiple comma separated values into single parameter…

  Ritesh_Dev

  12 replies

  14 years, 5 months ago

  By: Jared

• SQL Server DMVs

  I need to query SQL logins and their Server Roles, Securables, and Database Roles. What are the SQ…

  EdwinGene

  7 replies

  14 years, 5 months ago

  By: Lowell