SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Regex question

  A developer asked me to run a query based on the following regex: ^[A-Z]{4}[0-9]{4} Which means tha…

  BrainDonor

  4 replies

  5 years, 4 months ago

  By: BrainDonor

• INDEX REBUILDING DEGRADED PERFORMANCE

  Hi Experts, We have a stored procedure to search users. In order to improve performance i have rebu…

  arvind.patil 98284

  8 replies

  5 years, 4 months ago

  By: Grant Fritchey

• Sql server index

  Hi Experts , I have a job which calls 100 of stored procedure. I have identified the tables which w…

  arvind.patil 98284

  2 replies

  5 years, 4 months ago

  By: arvind.patil 98284

• how to check which tsql make increasing the log file size

  Hello, We set database log file size to 10GB, however database log file size is increased to 30 GB …

  ib3ans

  4 replies

  5 years, 4 months ago

  By: Jeff Moden

• Query single column data into three columns

  Hello: I have a table that has the JobNo and Time1 Columns. EmpNo    |    JobNo             |    Ti…

  stephen.aa

  11 replies

  5 years, 4 months ago

  By: Jeff Moden

• Filtering out based Start Date and End Date

  Hello, I have query contains both start and end date, i would like to filter out data based on two …

  koti.raavi

  2 replies

  5 years, 4 months ago

  By: Phil Parkin

• Need help with a BCP statement

  Hi, The code below produces a file and the view used here has rows. The problem is that is generate…

  itmasterw 60042

  11 replies

  5 years, 4 months ago

  By: Jeffrey Williams

• SQL 2012 ERROR - The metadata could not be determined because statement contains dynamic SQL

  Hi, This post is related to an error I have discovered through the execution of a SSIS package th…

  dtibz01

  17 replies

  5 years, 4 months ago

  By: Robin Wilson

• SQL server query is very slow because cache is too small

  My server have 2 instance: 1 version 2012 and 1 version 2017. Sometimes, instance sql 2012 (or sql …

  thaitinh77

  2 replies

  5 years, 4 months ago

  By: Grant Fritchey

• Arithmetic Overflow Error

  I am getting an Arithmetic Overflow error on this field, suggestions on a fix?   CAST(ROUND(CA…

  Jeffs1977

  2 replies

  5 years, 5 months ago

  By: Mr. Brian Gale

• sp_addextendedproperty for transaction log file

  hi there all, I am "playing around" with extended properties. I realized you can add them e. g. for…

  WolfgangE

  4 replies

  5 years, 5 months ago

  By: Steve Jones - SSC Editor

• An issue with an encrription function

  Hi, I am trying to get a Microsoft function to work with a variable. Below as you can see I am usin…

  itmasterw 60042

  2 replies

  5 years, 5 months ago

  By: itmasterw 60042

• Convert from nvarchar to numeric only if valid number-VAL command like MS Access

  Hi Folks, I have been struggling with this and tried several different methods with no success.  Al…

  joseph419

  4 replies

  5 years, 5 months ago

  By: Jeff Moden

• :on error exit statement

  Hi everybody, We have a policy in our Company that .NET developers are creating builds in VS and DB…

  AER

  1 replies

  5 years, 5 months ago

  By: Mr. Brian Gale

• Trying to find the date of a day for each month

  Hi, I have been looking allover and trying different things for this but cannot see hot to do this.…

  itmasterw 60042

  8 replies

  5 years, 5 months ago

  By: Jeff Moden