SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Correlated query to INNER JOIN or Window function

  I'm having some performance issues with a TSQL query. It's a complex statement but the main issue i…

  sql-lover

  14 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• task manager has been blocked from index Re-org

  This is running on sql server 2012, we have seup the databases on Availability group. The strange b…

  Sagar-636902

  11 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Index view won't work with hierarchical tables -- any suggestions?

  Consider following code: SELECT e1.EntityIdentity as CompanyID FROM dbo.Entitye1 --company …

  Mike Byrd

  3 replies

  11 years, 2 months ago

  By: serg-52

• CSV import to SQL having issues with non character data (Date & Decimal)

  I'm using OpenRowSet to import about 30 columns from a csv file with 190 columns with a format file…

  Paul Stasny

  1 replies

  11 years, 2 months ago

  By: Jeff Moden

• Identity on Uniqueidentifier

  Hello All, I am trying to set "Is Identity property" To Yes on a column that has uniqueidentifier a…

  tomy200501

  5 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• SQL Query - Possibly the most poorly written query in the history of mankind

  Having a major headache trying to tune this query and looking for help, a programmer who had no ide…

  atroyan84

  10 replies

  11 years, 2 months ago

  By: webrunner

• Database restore leaves the database with no dbo

  OS: Windows: 8.0 SQL Server: SQL Server 2012 Express SP2 Environment: •SSMS SQL Server 2012 •Comm…

  real.forte 18467

  11 replies

  11 years, 2 months ago

  By: ScottPletcher

• Column 'x' is invalid in the select list because it is not contained in either an aggregate function

  I feel like this should have been answered before, but I just couldn't find it. I have a specific …

  Dan Guzman - Not the MVP

  1 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Need help to insert into different database and table.

  Hi I need to insert sizes of 'adentureworks' database into 'mydatabase' (table 'size') -- Taken fro…

  Tac11

  5 replies

  11 years, 2 months ago

  By: Sean Lange

• syntax error

  Hello, I am trying to create some sql job which runs every few minutes.It will use below code insi…

  dallas13

  6 replies

  11 years, 2 months ago

  By: Scott Coleman

• unable to load data from flat file to sql table using bulk insert sql statement

  Hi, I am unable to load data from flat file to sql table using bulk insert sql statement my code:- …

  vipin_jha123

  1 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Select a matching rows which exist in particular string

  Hi, Suppose I have string like @strname varchar= = '3 April 15 abcd Oh rrrrrrrAAAAdd HJHJG' and ta…

  fanindrabhortakke

  4 replies

  11 years, 2 months ago

  By: Phil Parkin

• Crating and dropping global temporary table

  Hi , I want to create and drop the global temporary table in same statement. I am using below comma…

  vipin_jha123

  1 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Need help with Query design

  So I have a query that need to find the most recent datetime record each day for a customer. So I h…

  Fred Stemp

  4 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• How to optimize this query

  Hi can someone help me with optimizing this query -------------------------------------------------…

  Stanley Pagenel

  8 replies

  11 years, 2 months ago

  By: Grant Fritchey