Topics
Started by
Posts
Last post
Hi all, I'm trying to get an openrowset query to work and I believe I'm running in the permis…
3 replies
There were significant changes in 2016 to SQL columnstore indexes. I'm anxious to start using them …
13 replies
Greetings,I am interested in configuring our Azure SQL databases to use QueryStore. It seems like i…
1 replies
We have an SSIS Package that will do a One-time load into our Data Warehouse and then CDC will prov…
2 replies
Dear Forum members, I have a txt file which has several lines. below is a sample of those lines: Da…
3 replies
Hello, I have a line of code like: Filenameonly2 = line I get a result like: When I do messagebox.s…
8 replies
Hello, How do I troubleshoot/resolve this performance difference when parameterizing vs not paramet…
2 replies
Hello again, SQL experts, I'm facing an interesting challenge. I have a production process that run…
10 replies
Hi All Need some suggestions and clarity. Its a general basic question on Query tuning. Is there an…
5 replies
Hi , In my scenario , I am having last 24 month data in 24 diffrent table . In my target table ther…
3 replies
We've introduced SqlBulkCopy on a batch job that executes across multiple threads but are now getti…
1 replies
Hi, Is there any difference b/w 1 and 2 below? 1) INSERT MyTable WITH (TABLOCKX) ... 2)…
3 replies
Hi there,Is it possible to create a pivot table from more than one fields? [customer &nb…
2 replies
Hi, I'm currently troubleshooting a query performance issue against a partitioned fact tables that …
2 replies
I currently move data from an Oracle 11g DW to SQL Server 2016 by scripting SQLPlus (flat file out)…
2 replies
Viewing 15 topics - 2,296 through 2,310 (of 3,091 total)
You must be logged in to create new topics.