Viewing 15 topics - 3,991 through 4,005 (of 284,036 total)
Topics
Started by
Posts
Last post
What is the benefit in using a Windows Certificate issued by a CA (Certificate Authority), vs using…
3 replies
I am considering implementing an Azure Postgres DB for use in a part of an ETL process. I would nee…
1 replies
I have a database trigger on the DB that detects DDL changes, using EVENTDATA(). And then logs the…
2 replies
Hi all We've got some tables where the field order is .... odd. We designed the tables but, …
21 replies
CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert …
2 replies
Hello Gurus for one use case we converted the code to use temp tables as one of the Tables has 60 M…
1 replies
I want ,when Opening_value and Opening_Date exist in tabel #tbl_Account_L_Four ,then opening_Value …
4 replies
I wanted to share my findings with you (and a script) We have 24/7 workload with no downtime, up to…
11 replies
Hi All. I am seeing a scenario where SELECT is blocking a TRUNCATE statement in one of our prod env…
14 replies
hello, my query is select * into #TmpA from tblA (nolock). tblA contains 116000000 records. This qu…
12 replies
Good afternoon! Is there any type of documentation or process for failing over a CMS server? Do I h…
3 replies
Hi, This is my table and data, CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_003]( [Id] [int] IDENTITY…
4 replies
Comments posted to this topic are about the item Idempotent DDL Scripts That Always Achieve The Sam…
14 replies
Hi All, Need some help in tune a function which is reading TB's of data and because of which tempdb…
23 replies
Dears, In my company, we have certain master data domains like customer; Vendor; Product; Materials…
3 replies
Viewing 15 topics - 3,991 through 4,005 (of 284,036 total)