T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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

  14 years, 9 months 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

  14 years, 9 months 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

  14 years, 9 months 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

  14 years, 9 months 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

  14 years, 9 months 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

  14 years, 9 months 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

  14 years, 9 months 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

  14 years, 9 months 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

  14 years, 9 months 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

  14 years, 9 months 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

  14 years, 9 months 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

  14 years, 9 months ago

  By: Abhijit More

• Urgent: 8 Consecutive days worked

  Hi All, I have table with columns: [ASSOCIATEID] [LASTNM] [FIRSTNM] [STRNBR] [D…

  kotteesh

  1 replies

  14 years, 9 months ago

  By: spaghettidba

• how to create surrogate id for view in tsql

  hi, i have problem in tsql while creating the surrogate key for a view table. can any one hel…

  maheshkrishnas

  5 replies

  14 years, 9 months ago

  By: Jayanth_Kurup

• can we create surrogate id on view table

  Hi, this is my table i need to create a view table for this with surrogate Key can any one help on…

  maheshkrishnas

  1 replies

  14 years, 9 months ago

  By: Jeff Moden