SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Change column smallint to int 300 million records

  I wondered if anyone has found help changing a primary key fill factor before modifying data type f…

  Indianrock

  45 replies

  10 years, 1 months ago

  By: Sergiy

• Concat question

  I'm trying to understand the concat function. If I do this : SELECT custid, country, region, city…

  leehbi

  2 replies

  10 years, 1 months ago

  By: Phil Parkin

• Help with a cursor

  Hi there, I am using the following Cursor in order to populate multiple tables. /* This script pop…

  TSQL Tryer

  2 replies

  10 years, 1 months ago

  By: Phil Parkin

• Extract text from middle of string

  Hello all, I have a table with a field called FILE_NAME. This field contains a string of text: 0011…

  gaktheknife

  3 replies

  10 years, 1 months ago

  By: Ed Wagner

• Facing problems with memory/cpu pressure because of multiple executions of the code

  Hi, I'm actually facing an issue at this point, and there seems to be successive cpu/memory pressur…

  Feivel

  21 replies

  10 years, 1 months ago

  By: Alexander Suprun

• parallel execution of CTAS statements

  Hi, I have 10 CTAS statements creating temp tables. Once they are created, they are LEFT OUTER JOI…

  etl2016

  9 replies

  10 years, 1 months ago

  By: Sergiy

• Monitoring the resource usage of a user

  What would be a good way to monitor how much server resource a user is using over a period of time?…

  Maddave

  2 replies

  10 years, 1 months ago

  By: Maddave

• Rewrite the statement

  HI all, Decalre @day int Declare @date datetime = NULL SET @day = ( Select max(day1) FROM table1 WH…

  kapil_kk

  3 replies

  10 years, 1 months ago

  By: drew.allen

• Parsename - Replace - Strings

  Luis Cazares and Phil Parkin kindly helped me with the first problem. Problem 2 and 3 I need help w…

  Ganners

  2 replies

  10 years, 1 months ago

  By: Ganners

• insert does not insert in any order.

  q1) where ever i need order by to assign unique and sequencial number i use following while insert…

  rajemessage 14195

  7 replies

  10 years, 1 months ago

  By: Hugo Kornelis

• Load text file to multiple tables in SQL server

  i would like to load attached flat file(loadfile.txt) to two tables First table is #ShipmentTrackin…

  mxy

  6 replies

  10 years, 1 months ago

  By: Luis Cazares

• CHARINDEX

  Hello, can you help with this. I have list of 1000's of ID's - example below. 100||6||201203121235…

  Ganners

  5 replies

  10 years, 1 months ago

  By: Jeff Moden

• Stored Procedure that returns productivity numbers over two shifts with the second shift that spans midnight, need to implement date range

  Hello Folks - I've been working on a stored procedure that will return productivity numbers by shif…

  RickDowdall

  1 replies

  10 years, 1 months ago

  By: Sean Lange

• Query to find relational index options in sql server

  Hi, I want to find the all the relational index options for a table, is there a query to find all t…

  SQLFreak12

  4 replies

  10 years, 1 months ago

  By: SQLFreak12

• SQL Query improvement.

  I have a table("Applications") that stores leave applications. The leaves are stored in "StartDate"…

  KnowledgeSeeker

  2 replies

  10 years, 1 months ago

  By: KnowledgeSeeker