SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Can Cluster Index improve Performance?

  Hallo Everyone I have a small database of CMS system which does not have any primary key, relations…

  zahid.nawaz

  13 replies

  11 years, 5 months ago

  By: zahid.nawaz

• Query not returning all records in the table with not "where" condition

  HI, Today I experienced a weird problem I never faced before. There is a table which contains 1405 …

  mahesh.gupta 55272

  4 replies

  11 years, 5 months ago

  By: serg-52

• SQL newbie: How to extract all columns from multiple tables and save to a new table

  Dear friends, I have four tables. Table1 has four columns, Table2 has 3 columns, Table3 has eight c…

  Ashish Dutt

  1 replies

  11 years, 5 months ago

  By: spaghettidba

• Group by question

  Hi there I have a table with 3 ID columns, Name, Address Create table temp(ID1 varchar(10),ID2 va…

  rash3554

  5 replies

  11 years, 5 months ago

  By: Jeff Moden

• Calculate Distance between two UK Post Codes

  Hi, I want to be able to calculate the Distance between two UK Postcodes. So there will two parame…

  SQL_Kills

  4 replies

  11 years, 5 months ago

  By: SQL_Kills

• cte performance issue

  Hi This code has been written by a developer and it seems to be causing an issue performance wise. …

  PearlJammer1

  6 replies

  11 years, 5 months ago

  By: mister.magoo

• Is there a rule of thumb for number of rows in the partition for a very large table

  Hi Team, We have a 1.4 billion record table which will grow to about 4 billion in the next year or …

  sql_er

  8 replies

  11 years, 5 months ago

  By: Jeff Moden

• Questioning the effects of 100% CPU usage

  Today we had an incident with a server whose 2 CPUs got pegged at 100% usage. There is a SQL Server…

  Brandie Tarvin

  8 replies

  11 years, 5 months ago

  By: Brandie Tarvin

• Data Purge benifits

  I would like to do a purge for my 500 GIG database. Basically to remove data over 5 years. What are…

  SQL!$@w$0ME

  3 replies

  11 years, 5 months ago

  By: Anonymous

• Dynamically Convert Date/time from string Error

  The below code is throwing error Conversion failed when converting date and/or time from character …

  Priya004

  2 replies

  11 years, 5 months ago

  By: Luis Cazares

• Windows update

  KB 2992611 installed on MS SQL 2008 server, breaks ODBC access for remote clients. Please beware. …

  leonmccalla

  2 replies

  11 years, 5 months ago

  By: leonmccalla

• database rolls

  Hi We have created specific database rolls which give different levels of access to the individual …

  PearlJammer1

  1 replies

  11 years, 5 months ago

  By: Lowell

• this code works but looks ugly.

  Hi clever people! Is there someone that can make this code looks nicer and clearer? It just select…

  frdrckmitchell7

  7 replies

  11 years, 5 months ago

  By: serg-52

• Resource Governor - use with SQL jobs, Service Broker?

  Hi, I have a set of processes I want to throttle. Some are started by SQL jobs and some are started…

  digitalox

  2 replies

  11 years, 5 months ago

  By: digitalox

• Unused indexes, should I delete them?

  I have the following query I use to select unused indexes. I'm returning 140. I see some that I kno…

  dndaughtery

  6 replies

  11 years, 5 months ago

  By: SQLRNNR