SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Row Modification Audit

  We have row missing quite oftenly on our replication subscriber and we have no clue how rows are be…

  sqlquery-101401

  1 replies

  15 years, 10 months ago

  By: sqlquery-101401

• dbcc physical_only WITH (STATE =online)

  I want to run a DBCC check on a very large table but I want to keep the DB online at the same time.…

  smitty-1088185

  2 replies

  15 years, 10 months ago

  By: smitty-1088185

• Opening SSRS Solution

  Hey folks, I am an SSRS newbie. I've been tasked with troubleshooting and cleaning up a report cre…

  SwedishOrr

  4 replies

  15 years, 10 months ago

  By: SwedishOrr

• adding natural keys to fact table

  Hi all, I'm dealing with a relative large fact table. 60 million rows and ABOUT 14 GIGAbyte in size…

  M__M

  5 replies

  15 years, 10 months ago

  By: M__M

• Counting number of ties after Rank() Function

  Hi, I'm dealing with having to write some intense queries to do some golf statistics. My current c…

  pixelwiz

  3 replies

  15 years, 10 months ago

  By: pixelwiz

• store producers

  i want a stored procedure to get the list of indexes for a particular table. thanku

  bala2

  4 replies

  15 years, 10 months ago

  By: SQLRNNR

• SQL Query help

  Hi Please ignore thanks in advance...

  danny09

  3 replies

  15 years, 10 months ago

  By: danny09

• [error] Unable to connect to SQL Server database.

  When running the following commands: Setting environment for using Microsoft Visual Studio 2010 x86…

  Jon80

  9 replies

  15 years, 10 months ago

  By: Jon80

• Upgrading Database Compatibility Level When Database is already on 2008 SQL Server

  Is there a tool that you can use to tell what items may need to be fixed when upgrading to 2008? I…

  d33m

  4 replies

  15 years, 10 months ago

  By: Ninja's_RGR'us

• What to check first in server when we had issue with sql server

  Hi all, what are things that we need to check first when somebody all of the sudden says we have an…

  rajeshrajesh

  4 replies

  15 years, 10 months ago

  By: rajesh_0928

• DBCC TRACE

  i have turned on a trace by dbcc traceon, how wud i get the all information which is traced???

  Zeal-DBA

  2 replies

  15 years, 10 months ago

  By: Lowell

• Error converting varchar to int

  We have several clients upgrading to 2008. On some of the SQl boxes identical databases fail on var…

  rich-521822

  2 replies

  15 years, 10 months ago

  By: rich-521822

• SQL Server Maintenance Plan

  How we can copy maintenance plan from one sql server instance to another one?

  chetanr.jain

  1 replies

  15 years, 10 months ago

  By: Henrico Bekker

• Interview Questions

  Has anyone got any good Senior DBA interview questions ? [font="Verdana"]Justin Hostettler-Davies[/…

  JHD

  1 replies

  15 years, 10 months ago

  By: Henrico Bekker

• Web Service URL does not display correctly

  Hi All, I have SSRS 2008 on Win2003 server. When I go to the Web Service URL(.../ReportServer) it g…

  kkapitany

  4 replies

  15 years, 10 months ago

  By: nigel.