SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• 12(!) cached execution plans for the same stored procedure in production database

  I just noticed that there are 12(!) cached exec plans for a single stored procedure in my database.…

  Marios Philippopoulos

  10 replies

  16 years ago

  By: Gail Shaw

• maintence plan - Reports to Generate option

  Created a maintence plan in 2008 to back ups some databases and ticked the Reports to Generate opti…

  MarvinTheAndriod

  1 replies

  16 years ago

  By: Suresh B.

• Performance Monitoring - Perfmon / Large queries to database.

  Hi everyone, I am SQL Administrator in a insurance company in Denmark. Some times our users in diff…

  ArashS

  4 replies

  16 years ago

  By: ArashS

• Logon triggers - using EVENTDATA() versus system functions (SUSER_SNAME() etc.)

  Which is the preferred way of writing a logon trigger for basic user authentication? Using the EVEN…

  Marios Philippopoulos

  1 replies

  16 years ago

  By: TriggerMe

• SAN not starting fast enough for sql

  I've just finished installing a dell SAN on our network, have the new servers up and running 2008R2…

  mudbuddy11

  6 replies

  16 years ago

  By: Mark Shepherd-435962

• SQL Server 2008 Install fails to start

  I'm not convinced this is a problem with SQL Server but when I try to install SQL Server 2008 onto …

  GRE (Gethyn Ellis)

  1 replies

  16 years ago

  By: GRE (Gethyn Ellis)

• instances 2005 and 2008 side by side?

  Hello, if i have a server with 2 instances of sqlserver2005 (one named and one default), the named…

  ldemeyer@telenet.be

  2 replies

  16 years ago

  By: ldemeyer@telenet.be

• DR in the cloud

  Hiya I want to maintain a DR solution at AWS - I plan on having three VMs: MSSQL, Primary App/Termi…

  ramam

  7 replies

  16 years ago

  By: ramam

• Huge MSDB, cannot shrink

  I inherited an instance with a 65GB (yes gigabyte!) msdb. This is sql2008. I have verified that I…

  mark.mcnary

  8 replies

  16 years ago

  By: SQLRNNR

• confuse with result in dm_db_index_usage_stats

  Hi Guys, I'm randy, i'm quite new in the SQL 2008, i just wondering if someone can help on explaini…

  randy.mata

  5 replies

  16 years ago

  By: Nagesh S-432384

• Sql full text 2008 index not populating

  i configured full text index on a varchar column, but its not getting populated iam using sp2 windo…

  sukhoi971

  1 replies

  16 years ago

  By: sukhoi971

• Another Back up Question...

  Hi I am running a maintenance plan at which runs at 12.01am on a MS CRM DB This maintenance plan …

  nigelc

  12 replies

  16 years ago

  By: Steve Jones - SSC Editor

• prevent dbo access

  I hope this is not a silly question but here goes. Basically we have a staging database which devel…

  Adtjob

  2 replies

  16 years ago

  By: VastSQL

• Log parser

  Hi all, I am Trying to execute Log parser query through Xp_cmdshell like-- exec master..xp_cmdshell…

  DBA_1276

  3 replies

  16 years ago

  By: marklegosz

• LOGIN ,USER & ROLE PERMISSIONS

  Hi Experts, How can we find the privileages of each login and access to each database,users and its…

  VastSQL

  9 replies

  16 years ago

  By: VastSQL