Topics
Started by
Posts
Last post
Hello Everyone, I am facing some challenges with SQL performance, the database is SQL Azure. Please…
2 replies
Hi All, We have 100 tables in our database and I need to modify one datatype from Text to VARCHAR(M…
1 replies
Hello Experts,Following update Query takes about 1 Millisecond to update a Product reserve under le…
28 replies
Hi all, A client I work with has a database that has been customised by a vendor, which is causing …
8 replies
Hi,Is there a way to search SQL script inside SSRS reports?One of our linked server name is changin…
4 replies
Hello All, I have a table that has 5 encrypted columns. I'm using Symmetric Key for the encryption.…
9 replies
I have a very large stored procedure on my OLTP that runs multiple times concurrently based on user…
1 replies
SELECT CONVERT(VARCHAR(10), GETDATE()+2, 1) AS 'Date'unionSELECT DISTINCT User.id FROM User Msg 245…
7 replies
I have an SSIS package that creates a .xlsx from a query result. I then need to insert a new …
11 replies
I'm facing some issue to work out a database design, its a very small database that stores data of …
2 replies
When and how do you use a covering Index? For better, quicker answers on T-SQL questions, click on …
28 replies
Hopefully this isn't too daunting given that I'm providing a rather lengthy piece of sample code. …
14 replies
I have a column for ID in remarks table which is linked to customers table ID column The prim…
5 replies
Hi SSC, I ran across a block of code today which does deletes from a table in batches of 5000. Noth…
5 replies
Hello, I have created a SSRS report that displays items based on countries and States and pulls dat…
2 replies
Viewing 15 topics - 1,516 through 1,530 (of 3,067 total)
You must be logged in to create new topics.