SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Lookups on Clustered Indexes

  Hi All When I queried dm_db_index_usage_stats, I get user_lookups for a Clustered Index Here are t…

  Grizzly Bear

  10 replies

  15 years ago

  By: Gail Shaw

• HELP

  I have MS SQL 2008 and I have been running it for over a year. Last night I decided that I wanted …

  scott2366

  1 replies

  15 years ago

  By: Adiga

• Sql Query

  I need to print the results off my server of this query Select * from orders WHERE warehouseid='c' …

  Justin 17041

  3 replies

  15 years ago

  By: Ray K

• Poor Avg Read Write Wait times on SAN

  I am having very high read wait times on our OLTP system and would like to prove to our SAN vendor …

  sjs-36273

  2 replies

  15 years ago

  By: sjs-36273

• Number of TempDbs for certain types of processors.

  Hello, I understand that it is good practice to create the same number of Tempdb's as you have proc…

  Duran

  3 replies

  15 years ago

  By: Duran

• Updating a table from another table Based on the row conditions

  CREATE TABLE [dbo].[emp_stage]( [empid] [smallint] NULL, [ename] [varchar](7) NULL, [rowid] [int…

  nandakrishnacherukuri

  6 replies

  15 years ago

  By: ColdCoffee

• Modifying some xml

  Thanks for your help in advance. I am trying to edit some xml <resRefDate> <refDate>201…

  olibbhq

  2 replies

  15 years ago

  By: olibbhq

• Query works although subquery produces an error

  I found an interesting behaviour in SQL Server 2008: I have a query like this: (I know it could be …

  flinzer

  3 replies

  15 years ago

  By: flinzer

• difference between row_number and top in sql server

  Hi, what is the difference between row_number and top functions in sql server

  kuppurajm

  2 replies

  15 years ago

  By: VSSGeorge

• Detach database dropping connections

  Hey All, Is there a script to detach database w/ forcing to drop any existing connections? We have…

  A1Vijay

  7 replies

  15 years ago

  By: mangokun

• Reject Conflicting Dates

  I have a table with date ranges. I need a way to reject conflicting rows. How can I reject overlapp…

  BSavoie

  6 replies

  15 years ago

  By: Ron McCullough

• Slow Performance for Table with just 600000 Row

  Hi All, I am a newbie here, I have a table with 600K row, assume the table name is tbsales and it h…

  andika.chai

  5 replies

  15 years ago

  By: andika.chai

• NEED HELP SQL QUERY

  Dear all, I'm new to this site. I need help to write a query for selecting from two tables. I have …

  Nicky james

  6 replies

  15 years ago

  By: Jeff Moden

• RollBack Transaction

  I wand help for how to rollback the transaction.

  Dhukkaieswaran.N

  1 replies

  15 years ago

  By: Ron McCullough

• Creating Table

  CREATE TABLE 'Orders' ('Orderdate' VarChar(99999999999999999)NOT NULL default '', 'Orderid' VarCha…

  Justin 17041

  1 replies

  15 years ago

  By: Jeffrey Williams