I'd love to see Parquet being more widely used, and even become a standard data dump format (as opposed to CSV). The potential space saving and inbuilt column metadata definitions...

Hi sqlnoob,

Yes, you're correct that the impersonation is limited to the current query tab. My understanding is that each query tab has it's own session, and EXECUTE AS is scoped...

Hi Siten0308,

If those symbols are in the font, you should just be able to find out which character they are, and use the respective font and character. Use charmap.exe...

You don't want to be using "IN (SELECT PO_Detail_Status FROM dbo.DelimitedSplitN4K(@status,','))". You want it to be SELECTing the column that comes out from DelimitedSplitN4K.

Could you run the below and tell...

I use (and am grateful for) the string splitting function made by Jeff Moden on our pre-SQL 2016 instances. I suggest taking a look at his article on this

Hi juniormint,

This is nearly there. To correct your procedure, you need to have a "SELECT <column name> FROM " in front of "dbo.fnSplitStringList(@Status)". The column name is what the column...

@ronaldkunenborg apologies for the delay in responding. Thanks for the suggestion to push SalesOrder down into SalesOrderLine. I'm planning on moving the SalesOrder details to a dimension from...

@dmbaker: Thanks for your reply - I'm sorry I hadn't replied earlier. I think you've directly hit on some of those misunderstandings, and I really appreciate you taking...

• This reply was modified 4 years, 3 months ago by  Andrew P.

It sounds like you're on the right path - seeing this as a final option given that this behavior is severely impacting the business. I think it will work.

I second...

• This reply was modified 4 years, 8 months ago by  Andrew P.

Hi Sangeeth,

Yes, that's possible, but you do want to consider whether that URL needs to be stored/generated in SQL Server where it is consuming resources on the SQL server, or...

Hi Anton,

I can't see if you're using an AFTER INSERT or INSTEAD OF INSERT trigger. It sounds like you're having problems with an AFTER INSERT trigger, because you're describing that...

We use a date table, but not in a high-throughput environment. Here's my thoughts:

I recommend against #3 - requiring users calculate the date-related fields themselves (especially for the commonly used...

Hi Dhruva_51,

I recommend pasting the stored procedure text into SSMS, then running it (if appropriate), to verify you don't have invalid syntax.

If you're not able to, or the query is...

Hi SIJCOOKE,

If your table has a clustered index (one of these is created by default when a primary key is added to the table) on an auto-incrementing integer, then you...

Hi antonstar,

msdb holds Agent jobs. master holds logons, linked servers and system settings (and master database keys used to encrypt certificates), and model is the template database used when any...