SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Clustered Index and nullable column!!!!!

  I have a column 'A' with Data type (Uniqueidentifier, null) on the same column 'A' there is a clust…

  Dan121

  1 replies

  11 years, 4 months ago

  By: Gail Shaw

• Delete Vs Truncate difference on rollback

  I guess anyone who has read even basic SQL will be aware of this classy question. And most of the p…

  sqlnaive

  26 replies

  11 years, 4 months ago

  By: RK Mandava

• SQL Query - Simple Question

  Hi guys, We got a table in a form like this: Imagine it has millions of records! I'm looking for a…

  salardx

  1 replies

  11 years, 4 months ago

  By: Luis Cazares

• way to generate some random unique sequences

  Hi Experts, I need a way to generate some random unique sequences for one of the column (+5 increm…

  Jampandu

  26 replies

  11 years, 4 months ago

  By: aaron.reese

• Types don't match between the anchor and the recursive part in column "Hierarchy" of recursive query

  Dear all Following is my db table student_id student_code student_parent_id student_name 1 11 NULL …

  peterausger

  3 replies

  11 years, 4 months ago

  By: Jeff Moden

• How to procure IP Address of Symtem ??

  Hi, I have created a user registration form in which user have to fill Name,emil id, Phone Number. …

  gouri92

  1 replies

  11 years, 4 months ago

  By: spaghettidba

• Email ID formatting

  Hi, There is email address in my datablse table column as username I have to select it from databas…

  gouri92

  1 replies

  11 years, 4 months ago

  By: Eirikur Eiriksson

• sql server cpu schedulers

  Hi We have 4 Physical cpu's, Which are QUAD 2.4GHZ e7450on on an sql box. When I run the below quer…

  PearlJammer1

  8 replies

  11 years, 4 months ago

  By: Jeff Moden

• how to split a string and display it in different columns?

  dear all, How can i split the following string in sql server and display it in different columns? a…

  peterausger

  4 replies

  11 years, 4 months ago

  By: arrjay

• PK Question

  Hi folks, lets say i have a row which at the moment has an autoincrement as pk. Now i need several …

  Query Shepherd

  5 replies

  11 years, 4 months ago

  By: aaron.reese

• How to kill a sql server agent running job?

  How to kill a sql server agent running job? How to check how many jobs are currently running? Thanks

  forsqlserver

  7 replies

  11 years, 4 months ago

  By: cobrien 20540

• Replication: publisher delete data on subscriptor

  Hi, I had a sqlserver 2008 replication server working fine with sql server 2005 express. I had a pr…

  wolfbuda

  2 replies

  11 years, 4 months ago

  By: wolfbuda

• DR Solution - Log Shipping and Transaction Log Backups

  Hi there - I need to design a DR solution. We have multiple 1TB databases which have a full daily …

  arrjay

  4 replies

  11 years, 4 months ago

  By: arrjay

• SQL Service Pack 1, 2 ,3 ???

  Should I upgrade sequential .. 1, 2 and 3 ? or well soon update the last SP3? 😎

  chaplinux

  2 replies

  11 years, 4 months ago

  By: chaplinux

• Pulling my hair on this issue in SSIS (2008 r2):An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Incorrect syntax near the keyword 'SET'.".

  OK I got a very complex ssis package that needs to import data into tables of certain client system…

  Resender

  4 replies

  11 years, 4 months ago

  By: quackhandle1975