SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Cursor help

  Hi, I have made a stored procedure with a cursor: USE [DB_admin1] GO SET ANSI_NULLS ON GO SET QUOTE…

  maxlezious

  4 replies

  13 years ago

  By: maxlezious

• Need help on Powershell for SQL 2008 R2

  Folks , I created powershell script to be used with SQL 2008 which uses Invoke-sqlcmd . The script …

  nikhil.verma

  3 replies

  13 years ago

  By: Robert Klimes

• Unused Indexes

  Hello, I have been running the DBTA on a database to get some recommendations, I have the results, …

  Duran

  2 replies

  13 years ago

  By: Duran

• Converting Filestream to varchar/xml

  Hello everyone, We have an xml that has been converted into a filestream format and st…

  SqlServerNinja

  1 replies

  13 years ago

  By: SqlServerNinja

• PIVOTing multiple columns?

  I'm working on a PIVOT, and I can't see to get it to work. Here is the PIVOT query: SELECT * FROM (…

  DataAnalyst011

  12 replies

  13 years ago

  By: DataDog

• NOLOCK and PAGELATCH_SH

  I'm troubleshooting a latch contention issue at the moment. One of the symptoms operations noted du…

  pbowman-543344

  3 replies

  13 years ago

  By: Gail Shaw

• SQL query help

  hi guy i need help with a query!!! basically i have a table with l01 and 109 table looks a little l…

  mamzy.rahman

  9 replies

  13 years ago

  By: ChrisM@Work

• Ignoring timeout in stored procedure

  I know that this might cause a lot of suggestions about query optimization and such, but I have a s…

  Kurtman

  3 replies

  13 years ago

  By: ChrisM@Work

• uniqueidentifier scope?

  Hello - When a column is defined as a uniqueidentifier does that mean that the value is unique comp…

  sqlguy-736318

  2 replies

  13 years ago

  By: happycat59

• SQL Server and RAM utilisation

  Hi All, I am loading a table of data(1TB) from one server to other, I am loading it through SSIS us…

  SQListic

  1 replies

  13 years ago

  By: Lynn Pettis

• SQL 2008 - Resource Governor - CLBackup.exe

  Hello, We are having issues with a backup system (CLBackup.exe) taking too much CPU when it does a …

  DanielP

  3 replies

  13 years ago

  By: DanielP

• Storing files in a varbinary

  Hello, We have an app that copies files to a new location via unc...\\Server\Share. This however is…

  nfs_john

  3 replies

  13 years ago

  By: Steve Jones - SSC Editor

• Extract from xml stored as a varchar in a database

  Hello everyone, I need to extract information form xml stored in a database and store th…

  SqlServerNinja

  2 replies

  13 years ago

  By: Steve Jones - SSC Editor

• simple count in sql?

  I have a table structure as follows: guidA, market, isInMarket, guidB (lets just say all of these c…

  matthew.knudsen

  4 replies

  13 years, 1 months ago

  By: matthew.knudsen

• Replication - Subscription marked inactive and must be reinitialized

  I have transactional PUSH replication and recently got the following error: "The subscription(s) ha…

  SQL Guy 1

  6 replies

  13 years, 1 months ago

  By: sjimmo