T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• relationship between statistics and indexes

  Hello all. I have a table called 'Prt_cash_table'. In this table i have a column called as 'portfol…

  ekant_alone

  1 replies

  15 years ago

  By: Gail Shaw

• ADO.NET errorwhen reading table

  This may be a problem with ADO.NET and if responders believe this is not the correct forum, please …

  dbisignani

  4 replies

  15 years ago

  By: dbisignani

• Group The Date

  Hi Guru, How can I write a case statement to substract these below dates to be one singe value? Dis…

  Attopeu

  8 replies

  15 years ago

  By: Attopeu

• Log file shrink

  I am lookin on a server if a job has been setup to shrink a log file for a db. I dont see anything …

  sql_novice_2007

  7 replies

  15 years ago

  By: Gail Shaw

• Determine DB Recovery Model withing Sproc

  For some of my databases I am creating an automated script for index maintenance and backups. I hav…

  Daryl AZ

  5 replies

  15 years ago

  By: Paul White

• T-SQL Question: Getting different ways to reach from Point A to Point B

  Hi Guys, As per our requirement we have two list in UI. 1. Source 2. Target Both the lists are pop…

  Abhijit More

  11 replies

  15 years ago

  By: Abhijit More

• greater than equal

  Hi all, I'm having a debate with a colleague regarding the performance of greater than equal vs gr…

  kwhytee

  18 replies

  15 years ago

  By: cpreager

• Which pays more JAVA/C# programmer or SQL DEVELOPER or SQL DBA

  Hi I started as sql developer and did some C# but now in new project i faced some SQl DBA work too …

  rd2718

  1 replies

  15 years ago

  By: Daniel Bowlin

• Grouping and Getting Count of Consecutive Numbers

  Hello Everyone, Here is my problem. I have a table with a unique id, person id, day and a column ca…

  klanda20

  1 replies

  15 years ago

  By: Mark Cowne

• Updating multiple records in a single column

  Hi All, I am trying to update one of my column using update statement but when i execut…

  abhisheksrivastava85

  2 replies

  15 years ago

  By: abhisheksrivastava85

• Not able to drop Non-clustrered Index

  I want delete non clustered index on table but it is not hope. drop index NonClust_anamoly, sysname…

  SQL Galaxy

  7 replies

  15 years ago

  By: SQL Galaxy

• Fastest way to 1,000,000 individual DML operations for Change Tracking

  Long story short, I need to find the fastest way to force 1,000,000 individual DML operations (of a…

  Jim Foster 80123

  2 replies

  15 years ago

  By: Paul White

• SPLIT DATA SET IN TWO

  I am trying to split a data set into 2 sets using t-sql. I want on data set to have values based on…

  eseosaoregie

  7 replies

  15 years ago

  By: Orlando Colamatteo

• Null values to Int parameter in the Stored Procedure

  Hi I have a stored procedure and i do have 2 parameters Create procedure test ( @a nvarchar(100…

  Lucky9

  3 replies

  15 years ago

  By: Matt Miller (4)

• handle updates

  hi How you handle updates on table on sql server using cdc or something else. Thanks in advance

  daveriya

  3 replies

  15 years ago

  By: Abhijit More