Topics
Started by
Posts
Last post
I'm running the below. , Why is it failing when I cast it as nvarchar(max) but not when I cast it a…
4 replies
Hi,I am trying to alter datatype from TEXT to VARCHAT for multiple table in same database and I hav…
4 replies
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
Viewing 15 topics - 1,516 through 1,530 (of 3,069 total)
You must be logged in to create new topics.