Topics
Started by
Posts
Last post
Question: anyone tried deploying ssis to MSDB db in SSIS server using Azure pipeline? I am used t…
1 replies
On a monthly basis files are created to a network location from sql server. However this month is h…
5 replies
Ok so this is driving me nuts. My syntax is incorrect on this statement: create index IX_Service_…
4 replies
Due to the nature of a specific table and the needs of different development groups we need to spli…
9 replies
Hello everyone. Was just looking for some input on where I may get the best performance between i…
8 replies
WITH RECURSIVE factorial(F,n) AS ( SELECT 1 F, 3 n UNION ALL SELECT F*n F, n-1 n from factorial whe…
8 replies
So we have a block of code that I only want system account to run.. but if a user is db_owner.. the…
2 replies
I recently released my extension and wanted to share what I have learned so that others can start c…
7 replies
Im trying to rewrite our addin to an extension for SSMS 2016. I cant seem to find a way to add a me…
1 replies
All, I'm trying to compare two queries in terms of actual CPU and IO usage. In terms of IO the near…
5 replies
Hi I have a weird problem that I can't find the cause for. I have the statement below, it consists …
5 replies
Hi, I am looking for some solution where i can find out how much time did sql take to give full out…
5 replies
Hi all We've written some SQLCLR functions in C# to try and get rid of the UDF's we'd writte…
2 replies
I have a table that contains three columns with ID, dates and value. I want to convert the contents…
5 replies
My colleague wrote a following function to generate a table with 10,000,000 records, which works ab…
10 replies
Viewing 15 topics - 106 through 120 (of 3,062 total)
You must be logged in to create new topics.