SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• sum of running total from other partition (grouping sets?)

  I need to count the items between one lead row and other, here an example: I have this query: SELEC…

  Baldie47

  15 replies

  5 years, 5 months ago

  By: Baldie47

• Trying to delete a user from a database but getting an error

  I had to create a new user for testing, but running the app using this user id is acting weird so w…

  cFauvel

  1 replies

  5 years, 5 months ago

  By: cFauvel

• I was asked to get rid of this Dynamic SQL for performance purposes.

  Is it REALLY possible to bypass the @Where_Clause variable and make the below SQL non-dynamic? This…

  VoldemarG

  6 replies

  5 years, 5 months ago

  By: Jonathan AC Roberts

• Need explanation for below query what it does

    @Date1 = '20150630' DATEADD(m,6, @Date1) < DATEADD(m,-12,GETDATE())   Ignore this, i…

  mcfarlandparkway

  2 replies

  5 years, 6 months ago

  By: Jonathan AC Roberts

• WITH Query definition not working

  SELECT * FROM OPENQUERY ( [LinkedServer], ' WITH Disk_Size (Servername,DiskMountPoint,fileSyste…

  SQL Galaxy

  7 replies

  5 years, 6 months ago

  By: Jeff Moden

• Could you list db modeling tools you use on daily basis?

  Hi, while looking for new position I see beside  DBA and SQL skills(SSRS, SSIS, Powershell ..) comp…

  ebooklub

  18 replies

  5 years, 6 months ago

  By: ScottPletcher

• sql r equivalent

  Does sql server have equivalents for r language ie the r summary function?

  tinafmills

  3 replies

  5 years, 6 months ago

  By: MVDBA (Mike Vessey)

• Scalar function too slow - Calculated field in column based on another columns

  I have a big query, (really big, 800+columns - can't really make it smaller) that I'm trying to bui…

  Baldie47

  12 replies

  5 years, 6 months ago

  By: ScottPletcher

• DMS Error DFT Flow task

  Could any one let me know why i am getting this error?  on what basis these kind of occur errors? i…

  mcfarlandparkway

  1 replies

  5 years, 6 months ago

  By: mcfarlandparkway

• Need to replace this CASE statement in Where clause

  Need to replace this CASE statement in Where clause with something else (not CASE...), AND/OR (?). …

  VoldemarG

  6 replies

  5 years, 6 months ago

  By: Jonathan AC Roberts

• DBA activities

  The exam page fetches data from SQL Server. We are expecting 15K exams by this month end. What shou…

  coolchaitu

  4 replies

  5 years, 6 months ago

  By: Jeff Moden

• Query Tuning Question

  Is query tuning the responsibilty of a Developer or is it a combined responsibility of DBA and SQL …

  coolchaitu

  11 replies

  5 years, 6 months ago

  By: Jeff Moden

• Decrease a sum according to a dimension and according to a condition

  Hello all, First of all, thank you for dwelling on my problem. It is as follows: I want to decremen…

  samirca007

  1 replies

  5 years, 6 months ago

  By: John Mitchell-245523

• Procedure Error - has no parameters and arguments were supplied

  DECLARE @FROMDATE SMALLDATETIME, @TODATE SMALLDATETIME, @SERVER_NAME NVARCHAR(150) SELECT a.Se…

  SQL Galaxy

  6 replies

  5 years, 6 months ago

  By: pietlinden

• Standardized QA approaches for SQL Server

  Are there any frameworks out there to standardize, organize, or streamline the process of SQL QA te…

  imani_technology

  15 replies

  5 years, 6 months ago

  By: Steve Jones - SSC Editor