Topics
Started by
Posts
Last post
Doesn't seem right to me however i'm not as familiar w/ column store indexes
2 replies
The kind users of this forum have helped me develop a stored procedure that imports CSV files in a …
3 replies
Please assist? Need to write a query that returns the names of all the professors and their respect…
4 replies
Looking over a few data warehouse procs internally that we created by contracting firm. Noticed tha…
22 replies
I have a big ColumnStore table partitioned on a DATE column (billions of rows) That table is struct…
7 replies
I am having an error with this code: select customer_name, order_id, (case when sum(status =…
1 replies
Hi all, This code gives 2 results SELECT distinct(AtcCode) as id, Atc_Text FROM [dbo].[Drugs_Basic…
1 replies
On what basis should i compare performance of queries? Query 1: select * from dbo.Table1 where [T1…
6 replies
I have a DB full of RACES and RUNNERS, COURSES, STATS etc etc. One horse could appear in the table …
14 replies
I have a stored proc that isn't horrible, it runs in a few seconds, it just has high executions and…
33 replies
Hi Sir, I have some data, and I want to update the enddate columns data from table abc which has pr…
2 replies
Hi All, After a long time posting my query. It would be great help if anyone can assist on this. I …
4 replies
Hi there! I have an SQL table called ORIGIN with 5 fields. Each time one of the field in changing, …
5 replies
Example 1 declare @statement varchar(100) = '[dbo].[vw_EmployeeData]' select @statement, CHARINDEX(…
7 replies
Hello SSC, I hope everyone is staying safe and healthy. I am using SQL 2017 and I have over 17 mill…
3 replies
Viewing 15 topics - 211 through 225 (of 1,544 total)
You must be logged in to create new topics.