SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Execution plan over estimation

  Hi I'm running SQL on a 2008 box and it runs slowly. Looking at the actual execution plan there is …

  alex.palmer

  7 replies

  9 years ago

  By: Gail Shaw

• Update Statistics..

  Hi Experts,Trying to figure out if it might help in solving any performance issues by introducing a…

  Arsh

  23 replies

  9 years ago

  By: Arsh

• PLE

  Hi All, Appreciate if anybody can help understand why the physical memory is divided by 4 to determ…

  Arsh

  27 replies

  9 years ago

  By: Arsh

• Index Seek not possible if you want every row of table, correct?

  I have a table, it has a clustered index on customer_ID. I need to return every row of this table v…

  Maxer

  8 replies

  9 years ago

  By: ScottPletcher

• Removing records from SELECT

  Hi everyone I have a table in SQL called dbo.Orders The table has the following columns: Customer, …

  ByronOne

  5 replies

  9 years ago

  By: drew.allen

• 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

  We are facing a problem where CPU usage on SQL Server 2008 R2 spikes to 100% and during this period…

  muhammadaftab25

  19 replies

  9 years ago

  By: Jeff Moden

• Why Derived Table and CTE Over T-SQL ?

  Hello Database Experts !! I have to write a query using "AdventureWorks Database" which joins Huma…

  sunilchand

  2 replies

  9 years ago

  By: Luis Cazares

• Compare database structure

  Hi All   I am comparing databases( the structure) between test server and production so…

  WhiteLotus

  6 replies

  9 years ago

  By: Avi1

• DISK IOPS 25000

  Is there any way to control disk IOPS for heavily used database, i want to slow down the disk usage…

  goher2000

  3 replies

  9 years ago

  By: curious_sqldba

• Query cancelled but completed is 0...

  Hey,Just got another issue. One of our developers ran a BI query directly on the server and cancell…

  Arsh

  3 replies

  9 years ago

  By: Arsh

• security admin/db_security admin role permission issue

  Hi Team, I have a user who has securityadmin server role and db_securityadmin permission on the dat…

  SQLisAwe5oMe

  4 replies

  9 years ago

  By: SQLisAwe5oMe

• Right Size for LDF physical disk

  Dear friends,Please, help me to take action, the facts are:Big database 1.5 terabyte database size,…

  Lou

  14 replies

  9 years ago

  By: Jeff Moden

• Handling Transactions - Try/Catch - Error

  I have posted a similar question few days, i thought i got it but after i made code changes things …

  curious_sqldba

  1 replies

  9 years ago

  By: Gail Shaw

• do you have a StripNonNumeric ITVF function?

  we all know Inline Table Value Functions perform at least a couple of order of magnitude faster tha…

  Lowell

  45 replies

  9 years ago

  By: Jeff Moden

• datediff plus n days

  Hi The below code looks at the first time an identifier (customer) has requested re activation of t…

  Danii_Pink

  1 replies

  9 years ago

  By: drew.allen