Topics
Started by
Posts
Last post
We are trying to get the value from DB2 database table via Linked Server in SQL server 2016. The DB…
1 replies
i have an expression @[User::SharePath] +"\\"+ Replace(Replace(Replace(Replace( @[User::Fil…
6 replies
Hi All, My table have 2000000 records and size 60GB .when i take backup it will take time 60 min My…
14 replies
In the procedure i have date column as datetime2 declare @date datetime2 = null, @CaptureError var…
9 replies
I have an SSIS expression where it appends 20191125155915.xlsx to filename @[User::FilePath…
6 replies
Hello, I have the following queries that I want to group together in one optimized query. I would l…
5 replies
Hi, What to achieve (it is complicated to explain) : Set up a local DB on a SQL 2016 which contains…
1 replies
how to create triggers with delete and update i have a table called dbo.OrderDetail with columns (O…
7 replies
i am struggling with a query to avoid while loop, please guide me if it can be done without a while…
3 replies
insert into dbo.details ( DetailId ,DetailName ) select distinct st.stdid ,st.name from dbo.student…
3 replies
Good morning al I encounter a duplicate problem in the result of my query I have a doubt that the r…
6 replies
Hi, I have created a stored procedure that polls current activity on our server. I want the procedu…
1 replies
Hello, In following query there is a CASE sentence in SELECT clause but it isn't placed in GROUP BY…
3 replies
Hi All, We want to enable TDE on our Live databases. We will do it with downtime, however we are no…
1 replies
Hi Every One I have query optimization issue as follows. I have two related tables. Commodity (This…
7 replies
Viewing 15 topics - 1,156 through 1,170 (of 3,091 total)
You must be logged in to create new topics.