Could someone point me to some ideas about troubleshooting this error that I am gett…
5 hours, 15 minutes ago
I have inherited a database which has a number of system versioned (temporal tables). One o…
2 days, 2 hours ago
By: Jeff Moden
How to execute single query on different databases when one of the column missing in one databa…
2 days, 6 hours ago
I would be grateful if you can help me to calculate the RunRate(forecast) on the following table .
1 week ago
By: Mr. Brian Gale
I would like to create a calendar from a history table for a customer, so that I can read th…
By: Steve Jones - SSC Editor
I have a table with some data, Having hard time returning values based upon two conditions.
We've got some fairly lengthy pieces of (free)text we need to store for reporting pur…
1 week, 4 days ago
By: Jeffrey Williams
I have a web interface for managing tool rentals for our chapter members. I have a display page tha…
1 week, 6 days ago
By: jcelko212 32090
Does anyone find SSMS v.18 client to have a very slow start? ~30sec. to load and prompt for …
I would like to take input scripts and generate output data as given below. output is ex…
ALTER FUNCTION [dbo].[Max1] (@Dem Dec(18,6), @UnitCost1 Dec(18,6), @AnnCost1 Dec(18,6), @EBQ1 Dec(1…
in my datawarehouse i have large table with about 2.5B of rows. Table is partitioned by dat…
Is it reasonable to roll-up ALL metrics from Query Store to measure 'everything'?
and then compare …
2 weeks ago
I have a table Locations whose schema is below. I want to select all unique rows from the Home tabl…
2 weeks, 1 day ago
By: Phil Parkin
I have a FactBooking (BookingDateKey, Amount, Qnt) and a dimension DimDate(DateKey,Year,Month,W…
2 weeks, 2 days ago
Viewing 15 topics - 1 through 15 (of 2,197 total)
You must be logged in to create new topics.