General

• Topics

  Started by

  Posts

  Last post

• RESOLVED | Outer Apply in a Query & Not able to run TOP 1000 rows in a View

  Hi all, Very new to SQL & have 2 Different questions here please - Can you please explain what…

  sqlguru1day

  5 replies

  4 years, 11 months ago

  By: sqlguru1day

• INNER JOIN local table to Linked Server table, only first match returned

  I've recently noticed that when joining to a local table to a remote table through a linked server …

  jeff.born

  4 replies

  4 years, 11 months ago

  By: jeff.born

• Date Calculation with a Case Statement in a Query

  Hi all, Can someone please help with a easy one here. Thanks. The Below Query Returns : 123456 | 01…

  sqlguru1day

  1 replies

  4 years, 11 months ago

  By: DinoRS

• Executing SELECT statement in Debug Mode

  Hi Guys, I notice when i execute a SELECT statement in debug mode, i don't get the list of query re…

  Jacob Pressures

  8 replies

  4 years, 11 months ago

  By: Jacob Pressures

• Excluding deprecated columns from EF

  We have a handful of deprecated columns in a table that is referenced by multiple applications. We …

  TangoVictor

  1 replies

  4 years, 11 months ago

  By: Mr. Brian Gale

• My Left Join is NOT working - RESOLVED!!!

  Ok a lead programmer asked me to consider using a query construct that does not include EXCEPT.  Ra…

  Jacob Pressures

  6 replies

  4 years, 11 months ago

  By: Jacob Pressures

• Does anyone have the Microsoft Auto Index Tuning DB

  I have left my old job but cannot find a copy of the Auto Tuning Index DB TSQL that I used to have …

  Rob Reid-246754

  10 replies

  4 years, 12 months ago

  By: Rob Reid-246754

• ISNULL clause with a condition

  Hi, I've got the following code to select the period where I have active data: { FIXED : MAX(IF NOT…

  YariLei

  4 replies

  5 years ago

  By: Jeff Moden

• Question About Microsoft Data Migration and the MAP

  Hi, has anyone ever transformed the raw output generated by Microsoft Assessment and Planning (MAP)…

  imani_technology

  1 replies

  5 years ago

  By: imani_technology

• How to remove Scripting variables not defined in sqlcmd

  I've been executing the SQL script in sqlcmd and it has more arguments. Is there any possibility to…

  Whizkid

  5 replies

  5 years ago

  By: KerryBrown

• Regarding for Microsoft Azure Certification

  Hello Everyone, I am new here and I am preparing for microsoft azure certification but I am confuse…

  Ankitdixit

  3 replies

  5 years, 2 months ago

  By: Steve Jones - SSC Editor

• TSM TDP Backup > Automation for missing fullbackups

  Hello there, I am struggling to get TSM TDP to work properly with adjusted scripts. I want to imple…

  shp.shftr

  1 replies

  5 years, 2 months ago

  By: shp.shftr

• How to calculate a "DUTCHING" formula with an odds on runner < 2.00 price?

  I would provide a table creation script but I am getting the following error which I posted earlier…

  Rob Reid-246754

  4 replies

  5 years, 2 months ago

  By: Rob Reid-246754

• Replacing Winzip call in SSIS with 7-Zip?

  So I have a corporate mandate to remove WinZip from all our servers. We can use 7-zip, but I have n…

  Brandie Tarvin

  12 replies

  5 years, 2 months ago

  By: Brandie Tarvin

• I have a collation issue, should I change the database or all the columns?

  I had a SQL 2012 database on a dedicated server and I have taken it down to my local PC and an SQL …

  Rob Reid-246754

  10 replies

  5 years, 2 months ago

  By: Erland Sommarskog