SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Joining three tables

  I have the following sql statement. SELECT m.[property_id], m.[Address], m.[City], m.[Zip], m.title…

  tommy.ray

  2 replies

  14 years ago

  By: Kenneth.Fisher

• Join

  What is diff betn join and left join .Plz explain with example

  snadsul

  3 replies

  14 years ago

  By: SGT_squeequal

• GRANT SHOWPLAN for tempdb

  I am working with report writers in our test environment, and had to grant them SHOWPLAN on tempdb.…

  dkschill

  5 replies

  14 years ago

  By: dkschill

• How to open a .DTS package in the SQL 2000 DTS Designer

  I am migrating a SQL 2000 ETL process to SQL2k8R2. The old process uses sp_CmdShell to run a .DTS …

  Brandon Forest

  4 replies

  14 years ago

  By: Brandon Forest

• SQL Battleship Game

  Here's revised version of the classic Battleship game written in TSQL. Enjoy 😀

  swint002

  5 replies

  14 years ago

  By: RBarryYoung

• IN versus Equals

  I have stored procedures to which I pass strings for selection. Sometimes the string is a single el…

  pdanes

  8 replies

  14 years ago

  By: DiverKas

• Assigning a new SIZE value & subsequent SHRINK behaviour

  Hello, Any help on the following mystery please. I am puzzled why after altering my databases "size…

  raotor

  4 replies

  14 years ago

  By: raotor

• Use your own optimizer to tune your queries

  I will show how you could use your own Optimizer and statistics to tune queries which can not be tu…

  Gullimeel

  49 replies

  14 years ago

  By: Gullimeel

• Converting to Decimal

  I have some values in a column that are of the smallint datatype. Example values are 100 and 150. …

  GBeezy

  2 replies

  14 years ago

  By: Eugene Elutin

• Restore script help

  hi all, Im trying to write a little script for people to use for doing restores. We have 3rd part…

  Staggerlee

  5 replies

  14 years ago

  By: John Mitchell-245523

• Shortcut for Failover Cluster Management

  Hi, Like we have short-cut for cluster admin in windows 2003 ( i.e. - cluadmin.exe) Does we have an…

  chetanr.jain

  1 replies

  14 years ago

  By: Anamika

• Total Count - This should be easy.

  I want to get the total count each of the items of a column. So for instance I have data like this…

  tobinare

  2 replies

  14 years ago

  By: tobinare

• Data Types with Computed Columns

  I have a simple table with two columns containing integer values. I would like to compute a third c…

  c2k

  3 replies

  14 years ago

  By: Paul White

• Video url problem

  Hello friends, I am using sql server 2008 r2 and .net. I am passing video links in dynamic way. but…

  pallavi.unde

  2 replies

  14 years ago

  By: Devendrakumar

• Result to a variable

  Hi, Is it possible to store the results into a variable, not top1, but all the results. Thanks inad…

  mirravi

  12 replies

  14 years ago

  By: Jeff Moden