SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• IndexOptimize - Log Growth

  Hi All, I'm implementing Ola's maintenance solution on a 2008 R2 (SP2) instance. When running the …

  Kitch

  3 replies

  11 years, 3 months ago

  By: Kitch

• Basic Snapshot Isolation example not working?

  Just starting to use Snapshot Isolation. Allow Snapshot Isolation is turned on. I created this pro…

  Atat Rowcount

  2 replies

  11 years, 3 months ago

  By: Atat Rowcount

• How can I run this query for the current days business?

  SELECT c.cust_fullname AS Customer, c.cust_membership_id AS Account#, SUM(t.c_amount) AS ChargeTota…

  chef423

  9 replies

  11 years, 3 months ago

  By: chef423

• MSDB database huge - sysmaintplan_logdetail

  Hi all Help would be hugely appreciated as I'm all out of ideas on this one. I have a production se…

  MCM3

  5 replies

  11 years, 3 months ago

  By: ErrLog

• use sp_msforeachdb and sp_msforeachtable and sp_spaceused together

  hello I wonder if anyone has used these three procedures together? sp_msforeachdb and sp_msforeacht…

  aires

  4 replies

  11 years, 3 months ago

  By: SQLRNNR

• Question related SQl server trace?

  Please bare with me since I am still learning and let me know if you guys don't understand what I a…

  LearningDBA

  5 replies

  11 years, 3 months ago

  By: LearningDBA

• Set displayed characters programmatically

  Hi All, I just wrote a code-generating proc (it creates lines of code to execute in a different, pr…

  Xedni

  2 replies

  11 years, 3 months ago

  By: ErrLog

• DateTime and Decimal data types space handling!

  Hi, I have come to know that Date Time and Decimal data types occupy fixed space even if they do no…

  Celestial

  1 replies

  11 years, 3 months ago

  By: SQL Guy 1

• Latest date when date doesnt exist

  Hello Need some help to optimize one query, i can solve the problem using the Not In and subquery's…

  rootfixxxer

  4 replies

  11 years, 3 months ago

  By: rootfixxxer

• Remove last character after last space in a string

  Hi All, I'm having string values like mentioned below. String Values: George, Matt J Rambla, Tony G…

  vigneshkumart50

  4 replies

  11 years, 3 months ago

  By: Ed Wagner

• Use function like vlookup to find and replace value in SQL

  Hi, I am new to SQL server and I've been tasked to transfer some data from Excel to SQL, with some …

  yutuanfeng0109

  3 replies

  11 years, 3 months ago

  By: Neil Burton

• How to automise(dynamic) the following given report

  Hi, I had a table #DueAmount , which has detail date wise amount. For eg create table #DueAmo…

  avdhut.k

  2 replies

  11 years, 3 months ago

  By: avdhut.k

• XQuery help please.

  I'm have a Node in an XML string that I need to extract it's child nodes in order... What I should…

  CptCrusty1

  8 replies

  11 years, 3 months ago

  By: Eirikur Eiriksson

• View changing but not able to capture who/what is doing it

  Every now and then (about once or twice a month - no real pattern to it either) a column drops off …

  phingers

  14 replies

  11 years, 3 months ago

  By: phingers

• Diff between offline and online index rebuild operation

  Hi, Can anyone please tell me the difference between OFFLINE Index rebuilds and ONLINE Index rebuil…

  vsamantha35

  4 replies

  11 years, 3 months ago

  By: Gail Shaw