SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Instalation of Dabase of different version in same laptop

  For practice purpose, can install, MS SQL SERVER 2005, 2008, 2008 R2 in my laptop. Do I need to fo…

  Munabhai

  2 replies

  14 years, 1 months ago

  By: PaulB-TheOneAndOnly

• What I think is a Synonym

  Hello Everyone I am trying to troubleshoot some issues and I have ran across this "Alias", mostly i…

  AndrewSQLDBA

  1 replies

  14 years, 1 months ago

  By: Mark Fitzgerald-331224

• How to make an action on each row from a data set

  select distinct(employeeid) from dbo.rollingdutyrostershift where rollingdutyrosterid = 8) selects …

  Edvard Korsbæk

  6 replies

  14 years, 1 months ago

  By: CapnHector

• The multi-part identifier "" could not be bound.

  Hey guys , I am curently fallen in an adverse situation . I am at the end of my website and this si…

  deandeandeandean1

  4 replies

  14 years, 1 months ago

  By: Phil Parkin

• Return True or false from a SQL Stored Proc

  Hi Guys, Wondering if someone can help me, im creating a simple login page in my ASP.Net applicatio…

  .Netter

  3 replies

  14 years, 1 months ago

  By: Perry Whittle

• The multi-part identifier "" could not be bound

  Hey guys , I am curently fallen in an adverse situation . I am at the end of my website and this si…

  deandeandeandean1

  1 replies

  14 years, 1 months ago

  By: Gail Shaw

• MSSQL View

  There is a table in database having millions of records. Will view helpful to retrieve data faster?…

  pallavi.unde

  3 replies

  14 years, 1 months ago

  By: vinu512

• Performance and tuning

  In one interview the guy asked me a question regarding query performance as below, Suppose i have o…

  pallavi.unde

  17 replies

  14 years, 1 months ago

  By: Grant Fritchey

• CONNECTIVITY TO NAMED INSTANCE

  Hi, Thanks for reading my question. I have a named instance running on one of my development boxes.…

  Siva Ramasamy

  4 replies

  14 years, 1 months ago

  By: Siva Ramasamy

• user rights in simple terms

  I'm an "accidental DBA" attending to 8 production SQL Server 2005 (2) and 2008 (6) instances for a …

  daniel bliss

  1 replies

  14 years, 1 months ago

  By: daniel bliss

• Looking for SQL DBA job: hold MCTS and OCP DBA certificates, with limited SQL server experience

  Hi ! I hold OCP DBA certificate and years of experience with Oracle. My real life SQL Server experi…

  Oracle & SQL

  2 replies

  14 years, 1 months ago

  By: Oracle & SQL

• Estimate savings of backup compression

  Does anyone know a way to estimate the savings we will get with backup compression? Specifically t…

  Kenneth.Fisher

  5 replies

  14 years, 1 months ago

  By: Gail Shaw

• Msg 257, Level 16, State 3, Procedure procReceiveDeadLock_Graph, Line 28 Implicit conversion from data type xml to nvarchar(max) is not allowed. Use the CONVERT function to run this query.

  Hi folks can anyone help me to resolve this error please? Error: Msg 257, Level 16, State 3, Proce…

  SQlLogic

  8 replies

  14 years, 1 months ago

  By: CapnHector

• mirroring and replication?

  hi . what is the exactly different between mirroring and replication? and in which situation we can…

  Larry Page(Ehsan.Akbar)

  16 replies

  14 years, 1 months ago

  By: SQLisAwe5oMe

• Database Design

  Hello guys, This is a newbie question and I apologize from the get go, but Im having a hard time wr…

  asm1212

  2 replies

  14 years, 1 months ago

  By: asm1212