SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Login audit

  Hi, I've been asked to produce a report on who has accessed a particular database on an SQL server …

  Walshy

  2 replies

  13 years ago

  By: tarun777.pant

• Question about MAX_QUEUE_READERS in Service Broker.

  Guys, I have a Question about MAX_QUEUE_READERS option in Service Broker. In a high transaction env…

  WangcChiKaBastar

  2 replies

  13 years ago

  By: WangcChiKaBastar

• Percent to Total - Customer Sales Penetration

  This is related to a previous post, but I didn't have all the information. Now, I'm including the s…

  rarascon

  2 replies

  13 years ago

  By: rarascon

• Ports and Firewall changes for named Instance

  Hi All, What all ports should be opened for a named instance, which is listeneing on 1477. The name…

  SQListic

  7 replies

  13 years ago

  By: @SQLFRNDZ

• "SET STATISTICS TIME" and "SET STATISTICS IO" questions

  1) As I understood from here [/url] "elapsed time" is the total time of statement's execution, but …

  MaxNevermind

  5 replies

  13 years ago

  By: arnipetursson

• ?? on Job Steps and how they work

  Hi, I'm trying to setup a job w 2 steps step1 run and emails a report via SSRS, I just created a su…

  jbalbo

  5 replies

  13 years ago

  By: jbalbo

• Rebuild or DBREINDEX

  Hi I have a table with a clustered index and 6 non clustered indexes.The size of the table is 400G…

  mah_j

  18 replies

  13 years ago

  By: Orlando Colamatteo

• why there are no sql server services listed in configuration manager

  In installed another named instance of same edition and version sql server 2008 r2 on a server. Now…

  SQListic

  3 replies

  13 years ago

  By: SQListic

• Sql server 2008 installation problem( must specify valid information for parsing the string)

  Hello, When i am trying to install sql server 2008 using iso file , it shows an error message " mus…

  tintuanbijo

  1 replies

  13 years ago

  By: @SQLFRNDZ

• Discriminator Field

  Hi could anyone tell me whya discriminator column would be added to a table? what is a discriminato…

  erics44

  2 replies

  13 years ago

  By: erics44

• Using MERGE tsql for FACT loading

  Hi All, I m using the below tsql MERGE statement for loading data to one of the fact table in DWH d…

  sam 55243

  6 replies

  13 years ago

  By: Lydiart

• Create SSIS package in SQL SERVER 2012 for SQL SERVER 2008

  Is it possible to develop SSIS packages in SQL SERVER 20012 for deploying in SLQ SERVER 2008?

  Aspet Golestanian Namagerdi

  7 replies

  13 years ago

  By: kalyan_chakravarthy

• Restoring SQl SERVER 2008 R2

  Hi Guys: Any guide how to restore sql server 2008 r2 backup on sql server 2000 thanx symun

  irayanban

  7 replies

  13 years ago

  By: Sean Lange

• Lazy Writes / sec

  on one of my servers i checked the Lazy Writes / sec and i get a very very high value of 2635802. e…

  idokle

  2 replies

  13 years ago

  By: Igor Micev

• count(*) vs count(1) or count(id)

  Dear Experts, I want to know what is difference between count(*), count(id) and count(1) base on pe…

  ashkan sirous

  4 replies

  13 years ago

  By: Loundy