Topics
Started by
Posts
Last post
I am using SQL Server 2008R2, I want to encrypt all database objects before sending these to Produc…
15 replies
Hey guys, please help me My xml is in below format: DECLARE @MyXML XML SET @MyXML = '<RS> &…
2 replies
I'm trying to use CASE WHEN to group insurance data. I need three groups, Medicare, Medicaid, and A…
2 replies
Hi Guys, I've been having trouble merging NOTES in the one table depending on the contents of anoth…
5 replies
Gents, Is there a simple (or more complex) way to search all scripts (SP/Jobs) in search for a spec…
3 replies
I have the following script: --Updated connection string :CONNECT sql.mc.com -U [AdminAccount] -P …
2 replies
Hi All, I have customer_Contact table with customer and contact details as below. CUSTOMER …
1 replies
We had a differential backup failure yesterday with Error: 3041, Severity: 16, State: 1. After a …
1 replies
Hello. I am new in sql. I recently encountered runtime error while writing stp. In my stp, i insert…
1 replies
Can someone provide guidance on how to get SSIS set up? In order for an end user to use some of it…
39 replies
When adding an extra data file to a database, is there any (performance / backup / any other relate…
1 replies
Hi This is a question from a high level view about the possibility of removing a cursor from some o…
3 replies
If I have millions of records with the format . Customer | transaction start date | transaction en…
1 replies
I have a query that takes 20 seconds. I need to speed it up. Table is partitioned and indexes are i…
2 replies
If a table column has a datatype say VARCHAR(5) but the sproc references the column as Declare …
3 replies
Viewing 15 topics - 5,191 through 5,205 (of 30,225 total)
You must be logged in to create new topics.