T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Very frustrating performance tuning!

  So I have run into this most aggravating of issues 😀 Here is what I have; I am loading sales order …

  shannonjk

  7 replies

  13 years ago

  By: shannonjk

• Inner join vs Left join

  Hi Everyone, I'm experiencing something I don't expect and I'm hoping someone can shed some light. …

  SpinyNorman

  8 replies

  13 years ago

  By: Eugene Elutin

• Generate Script

  Hi All Is there anyway I can use the below script to generate CREATE DATABASE commands? select DB_…

  SQLSACT

  2 replies

  13 years ago

  By: SQLSACT

• DateDiff help to verify my code is correct or not?

  Hi Friends, I'm using DateDiff function - my requirement is - 1) "SmartLaborII Job Posting End Dat…

  dhananjay.nagarkar

  8 replies

  13 years ago

  By: Sean Lange

• delete query SQL 2008 in Virtual machine setup?

  Hi, I am going to delete the records for last 2 years, and total number of rows 31935523.. Should I…

  SQL Galaxy

  2 replies

  13 years ago

  By: Lynn Pettis

• Single Update Query - Required

  Table 1: SnoSIDSname 1NullA 2NullB 3NullC 4NullD 5NullE Table 2: anoaIDaName 155…

  ManiDBLover

  6 replies

  13 years ago

  By: ManiDBLover

• What needs to consider when adding a password to the table

  Hi There, Could you please help me out, i have table with 9 columns and about a million rows, i nee…

  asita

  5 replies

  13 years ago

  By: Eugene Elutin

• Hierarchy example - Ken Henderson's book - not working

  I’m working on the hierarchy lesson in Ken Henderson’s The Guru’s Guide to Transact-SQL. He wants t…

  polkadot

  18 replies

  13 years ago

  By: polkadot

• How to make triple-pass UPDATE single-pass?

  I'm attempting to optimize some code that I was just handed, and I'm not exactly sure if what I wan…

  sqlnyc

  12 replies

  13 years ago

  By: sqlnyc

• Query Help

  If I want to Sum a field where the date has passed, how would I do that? So my goal would be to Sum…

  mbrady5

  4 replies

  13 years ago

  By: Sean Lange

• Split a String

  Hello Everyone I am working on some old data that should not be store this way, but it is. My data …

  AndrewSQLDBA

  14 replies

  13 years ago

  By: Jason Wolfkill

• How do I optimize a query with a text column?

  I am looking for a way to optimize a SELECT query that includes a column with a data type text. I c…

  Hawkeye_DBA

  17 replies

  13 years ago

  By: Jason Wolfkill

• Create SP on Multi-Server Query

  I have a dilemna. I like to use multi-server quesier to push out my code; however, all my SP's use…

  GregoryF

  3 replies

  13 years ago

  By: Erin Ramsay

• Insert Performance

  Hi, Which will perform faster/better inserting million rows to a table or put all insert in a trans…

  radRCL

  13 replies

  13 years ago

  By: TheSQLGuru

• Complex SQL QUERY with DateDIFF

  Hi all, I need to script a query to discard access logs that not exceeding a predetermined margin (…

  costasbd

  37 replies

  13 years ago

  By: ChrisM@Work