Is there a better/more efficient way to do what the below does? It is replacing several character…
2 days, 4 hours ago
By: Jonathan AC Roberts
Could you please help?
My Union all sql query consist of three individual queries that runs quickly…
3 days, 3 hours ago
we have a new SQL site - and included Availability Groups in the install.
set up is 2 servers - wit…
4 days, 15 hours ago
By: mark seidelin-407018
I know that the DATETIME data type is no longer an ANSI/ISO Standard and I have heard the Microsoft…
1 week, 5 days ago
By: Dennis Jensen
I have a situation where I ran into an old school query that I want to change into a more standardi…
2 weeks ago
By: Jo Pattyn
I have a requirement where I am trying to get the active group number.
A groupnum can ha…
4 weeks ago
We are trying to understand why we are seeing the following occasional deadlock in our test environ…
1 month ago
I have a batch process where i have to delete around 75 MIL rows out of 1.3 Billion rows table. A…
By: Stewart "Arturius" Campbell
Perhaps a silly question, but may significantly impact the business.
We have recently fo…
By: Jeff Moden
I'm trying to retrieve all the records for the most recent date. I have used Max on the […
1 month, 1 week ago
I have a dataset of route data (this is just a single route) like below:
CREATE TABLE [dbo].…
1 month, 2 weeks ago
I want to query a table that has a datetime column ([CreateDateTime]) and get the week number for…
1 month, 3 weeks ago
i try to understand why my procedure do not respect the loop in batches of 10 until the end. i …
By: Jeffrey Williams
I have come across this peculiar problem.
This stp is called every begin of the day of the a…
Not sure if this is possible. I'm looking to insert a new row into a temp table if a field on t…
Viewing 15 topics - 1 through 15 (of 2,985 total)
You must be logged in to create new topics.