SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQLServer2008 Administration Certification - Dumps

  Dear All, Can someone provide the dumps for SQLServer 2008 - Administration Certification ? please …

  ravisamigo

  4 replies

  14 years, 11 months ago

  By: Grant Fritchey

• Passing comma saperated list into stored procedure is having problem

  Hello guys, I want to pass comma saperated list into the stored procedure and I am referencing the …

  kunaal desai

  5 replies

  14 years, 11 months ago

  By: GSquared

• Big nested loop - Is my SQL sensible?

  I'm working on correlations so I have, say, 10 time series, from which I need to generate 10 x 10 s…

  AlistairNY

  7 replies

  14 years, 11 months ago

  By: GSquared

• Parameterize all your queries using the sp_executesql - what does it mean

  I just read the text below on a site where the author is giving tips for improving performance in S…

  webskater

  2 replies

  14 years, 11 months ago

  By: Grant Fritchey

• delete stored procedure for relationship many to many

  Hi, I have the tables : - Customer (CustomerId, Name, ..) - CustomerAddress (CustomerId, AddressId,…

  dg78

  3 replies

  14 years, 11 months ago

  By: lionfan91

• Stored procedure encryption / decryption

  Upto SQL server 2005, the 'decrypt' function is working. In 2008, that is not working. I need to ch…

  zyxcba01 11808

  1 replies

  14 years, 11 months ago

  By: Adi Cohn-120898

• How to split a single record in multiple records based on a datetime period?

  I am completely disoriented with this problem. I really appreciate if you can give me some hints ab…

  XMLDbJavaDev

  22 replies

  14 years, 11 months ago

  By: andrewd.smith

• copy of backup files

  i have two servers A & B. A is running with local account and B is running with do…

  ramyours2003

  2 replies

  14 years, 11 months ago

  By: ramyours2003

• Migrating SQL Server

  Hi Friends, I have recently been assigned to move SQL 2005 running on Windows 2003 server to a ne…

  latokiro

  4 replies

  14 years, 11 months ago

  By: latokiro

• SQL Script for backup path

  Hi, What is the way to list the backup history? Thanks

  latokiro

  2 replies

  14 years, 11 months ago

  By: latokiro

• unique Index for existing table with duplicates

  Hello, I have a table with 150,000 records. The application was developed to catch the users entri…

  WebTechie

  5 replies

  14 years, 11 months ago

  By: WebTechie

• How to see & output data > 8192 in varchar(max)

  I have a situation where I need to provide a fixed format flat file to a client. The problem is the…

  nimmi.smith-624103

  7 replies

  14 years, 11 months ago

  By: Ghanta

• permision in database

  i have 2000 table in database and 10 person have access to all structur and data and edition in tab…

  a.e.ghorbani

  1 replies

  14 years, 11 months ago

  By: Adiga

• BINARY vs VARBINARY ---- How to decide for a given scenario

  Requirement : Storing a XML piece of data in hashed format in a column. This will be a PK column. …

  Deepak Kolapkar

  7 replies

  14 years, 11 months ago

  By: mister.magoo

• change the following query to storedprocedure

  select AccountDim.accountbranchnumber,AccountDim.accountdimkey,AccountDim.accountnumber, AccountDim…

  koolme_85

  19 replies

  14 years, 11 months ago

  By: Jeff Moden