SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Index Fragmentation

  Hi Experts, For the below query i am getting four fragmentation levels why?? SELECT avg_fr…

  VastSQL

  3 replies

  11 years, 8 months ago

  By: Grant Fritchey

• Can SQL Server 2008R2 SSMS be used to create maintenance plans on a SQL Server 2000 database.

  I am currently running SQL Server 2008R2 on Windows Server 2008R2. I am remotely connected to a Win…

  hmbtx

  9 replies

  11 years, 8 months ago

  By: SQLRNNR

• virtual file size

  We have some monitoring sofware. Sometimes I am confused about concepts about paging related. For e…

  sqlfriend

  2 replies

  11 years, 8 months ago

  By: SQLBuddy123

• Can't start SQL Server Browser

  I'm having issues trying to connect outside of the box with msss and I noticed that the SQL Server …

  DKY

  3 replies

  11 years, 8 months ago

  By: SQLRNNR

• 3rd Party Backup Utility Hangs

  I have an Network Administrator running a 3rd Party Backup Utility on an instance of SQL Server. On…

  Welsh Corgi

  9 replies

  11 years, 8 months ago

  By: Welsh Corgi

• Database Mail Not working after SQL job completed.

  I am running script from SQL agent which includes Database mail script also when job is running suc…

  SQlLogic

  3 replies

  11 years, 8 months ago

  By: SQlLogic

• syspolicy_purge_history failing

  Hello, I have a clustered (active-passive) SQL Server cluster running under version 10.0.4000.0 (SQ…

  Peter Vramby

  6 replies

  11 years, 8 months ago

  By: sankartosms

• Duplicate Records

  How do I delete duplicate records in sql server 2008?

  vsamuel

  3 replies

  11 years, 8 months ago

  By: SQLRNNR

• Impact of INdexes

  Hi experts, What is the different of impact between the below two indexes. 1)CREATE NONCLUSTERED IN…

  VastSQL

  3 replies

  11 years, 8 months ago

  By: Grant Fritchey

• Index Fragmentaion of particular indexes

  Hi Experts, how can i get the fragmentation level of particular indexes(around 1000) alone?

  VastSQL

  6 replies

  11 years, 8 months ago

  By: Grant Fritchey

• Modifying a column datatype

  Hi Experts, I need to change the datatype of a column from INT to BIGINT. The column is having IDE…

  VastSQL

  7 replies

  11 years, 8 months ago

  By: VastSQL

• Difference in UNique Non-Clustered and Non-Clustered

  Hi Experts, Is there any difference in unique Non-Clustered and Non-Clustered and non-clustered in…

  VastSQL

  3 replies

  11 years, 8 months ago

  By: Grant Fritchey

• Network Drive mapping-Automation-Production issue

  Hi, I deployed small batch file in startup in window server.whenever we are restarting the server b…

  selvakumar.sms

  6 replies

  11 years, 8 months ago

  By: SQLBuddy123

• help me to schedule this index degragmentation query

  Hi, I am using this query to get the fragmentation above 30% and i would like to schedule this ind…

  Gangadhara MS

  4 replies

  11 years, 8 months ago

  By: george sibbald

• Just one database timed out on the server?

  Hey guys, I got this interesting error over the weekend, where just one database on the server time…

  DVSQL

  7 replies

  11 years, 8 months ago

  By: SQLBuddy123