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