T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 16 % -index selectivity -good or bad ?

  Hi Experts, I have a non clustered index defined on a column with 4 included c…

  chaithu559

  4 replies

  14 years ago

  By: george sibbald

• Adding Clustered index to table that has a non clustered index

  Hi Experts , I have a table which has non clustered index defined on the a colu…

  chaithu559

  2 replies

  14 years ago

  By: Suresh B.

• Calculate weeks for past months

  Hi I need a sql that takes the input as date from user and calculates the no of weeks for last two …

  nehaCS

  9 replies

  14 years ago

  By: ChrisM@Work

• Adding extended properties to stored procedures/functions

  Hello All, I am trying to add 4 extended properties to the 250 stored procedures and 200 functions …

  SQL Prog

  2 replies

  14 years ago

  By: Lowell

• How Nonclustered index uses Clustered index

  Hi Experts, I have read in many articles . It says that If a table has clustered i…

  chaithu559

  1 replies

  14 years ago

  By: Gail Shaw

• Getting result from different server and using it in another server

  Hi, I have a tableA in server X. I need to query TableA to get couple of column data results and th…

  Krithika K

  2 replies

  14 years ago

  By: Andrew G

• xml input for stored procedure

  consider i have 2 tables . table1 n table2 with similar columns(empno,ename,salary) thr is a input …

  BeginnerBug

  3 replies

  14 years ago

  By: moh.sharma333

• How to find out who has looged on to my machine yesterday

  Hi Everyone, How to find out who has looged on or connected to my sql server…

  chaithu559

  3 replies

  14 years ago

  By: Rock from VbCity

• Comma delimited string in a Subquery

  Can this be done? I can get a query to return a comma delimited string of results using Coalesce bu…

  tshad

  5 replies

  14 years ago

  By: tshad

• Using the DelimitedSplit8k function - Help Jeff!

  I don't fully understand how the splitter and the tally table works well enough to use it for alter…

  MyDoggieJessie

  18 replies

  14 years ago

  By: Jeff Moden

• Need help with creating StoreProc

  Hi all, I'm new to SQL, any instructions or sample code to create the Store Proc below would be gr…

  SueTons

  10 replies

  14 years ago

  By: David Webb-CDS

• massive delete

  I'm going to delete about 8 million recs from a table who has 27 milllion records. I had planned on…

  BaldingLoopMan

  9 replies

  14 years ago

  By: BaldingLoopMan

• Stored Procedure with dates

  Hi, I have the below data: HOSTNAMESERVERCHANNELDATE COUNTER_NM COUNTER_VAL T…

  dsrapid

  15 replies

  14 years ago

  By: dsrapid

• Delete all users and roles from all the db's

  Wanted to drop all the users and roles from the database which is recently restored from other envi…

  khushbu

  9 replies

  14 years ago

  By: Geoff A

• Purge Process Issue

  Hello, I have a question on a purge process. I have one main “Stage” table and other 10 transitions…

  sqlquest2575

  1 replies

  14 years ago

  By: Lynn Pettis