I have a lot of SQL update queries where I need to make IF/ELSE types of decisions. In some cases, I am using a cursor but looping through thousands of rows for update takes a long time. I also use some dynamic SQL to handle some query parameter decision making. Is there a better alternative?
Loading data into Snowflake is a common need. Using Python and pandas is a common go-to solution for data professionals
See how ISNULL and COALESCE behave in different situations and ensure you know which one to pick when.
Windows 7 support is ending, but Microsoft doesn't have a good plan for home users. Steve notes that the OS upgrade treadmill ought to come to an end soon.
How are you navigating the database landscape? Our latest report sheds light on the current state of database management and offers valuable insights into how organizations can navigate and simplify the growing complexities of the database landscape.
I have heard of the default trace in SQL Server. I know it’s on by default, but I don’t know how to use it. What can I do with the default trace?
Today Steve is wondering how you approach coordinating application and database changes. Share which one you deploy first.
Learn how you can create a full data load process in Fabric.
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Comments posted to this topic are about the item Create an HTML Report on...
Hi I have a SP that occasionally get this error: Cannot resolve the collation...
Hi everyone I am getting an error when I create the index but I...
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers