Topics
Started by
Posts
Last post
hello, my query is select * into #TmpA from tblA (nolock). tblA contains 116000000 records. This qu…
12 replies
When ASCII(Column) is null, what does it represent? Is this some kind of special/control characters…
5 replies
Hello, Converting file name MMDDYYYY.txt to a Date Field but CONVERT or CAST do not seem to work pe…
14 replies
Hi everyone, I have a XML file in which data looks like this: <ArrayOfHomeModel xmlns:i="http://…
15 replies
Hello experts, Could someone point me to some ideas about troubleshooting this error that I am gett…
5 replies
Hello, I need to setup a Stored Procedure to run on the first Monday of each month that is not a ho…
22 replies
We have several tables with system_versioning set to on. There is a requirement now to produce a so…
2 replies
When Running a stored procedure how i can track which records got created, updated and deleted as a…
1 replies
Hello everyone, Was looking for some feedback before I make a DB object change. So, I have a part…
4 replies
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
Viewing 15 topics - 91 through 105 (of 3,056 total)
You must be logged in to create new topics.