RE: publishing execution of sp
If you change the stored proc, u have to regen the snapshot. Otherwise the subscriber will not have the same proc
2003-07-01
Clustering
RE: Determining size occupied by each row
Thanks, I think that might be exactly what I need. I just did a quick test and it seems to calculate out everything nicely - even the text and n* columns. If this does work, it'll wind up being a lot easier that I thought the process would be. I scoured the Books Online and […]
2003-06-29
2 reads
RE: implement parent and child in build of materials “
Coming along just fine. Here are the answers to your questions: 1) Yes, both BOMProduct and ProductDependent have composite PRIMARY KEYS: --Using my original schema... ALTER TABLE BOMProduct ADD CONSTRAINT PK_BOMProduct PRIMARY KEY (BOM, Product) , CONSTRAINT FK_BOMProduct_BOM FOREIGN KEY (BOM) REFERENCES BOM (BOMID) , CONSTRAINT FK_BOMProduct_Product FOREIGN KEY (Product) REFERENCES Product (ProductID) -- ALTER […]
2003-06-27
2 reads
RE: Best practice when to use an index
Interesting question. I guess the answer is six of one and half a dozen of the other. With regard to parameter tables in particular I always tend to give these an Identity column as a Primary Key. Why? well firstly it's safer to be very clear about which parameter you want to use and an […]
2003-06-24
1 reads
RE: Seeking SQL Server DBA's with Healthcare Industry
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-23
RE: eliminating duplicates from stored procedure joins
There's more... Try the performance if this (remember the execution plan will be saved for this query in proc). SELECT DISTINCT a.* FROM ( SELECT Case30.Case_no#, Case30.Last_name, Case30.[First Name], Case30.Determination, Case30.Sender, Case30.[Case Type], Case30.Date, Case30.[Qwik Due], Case30.[Qwik sent date], Case30.[Final due], Case30.[Final sent date], Case30.[on hold code], tblFileNames.reportid, tblFileNames.type, userviewed.viewid FROM tblFileNames Left Outer Join […]
2003-06-20
RE: Importing 5 million rows of data every day?
i would suggest you add two more new columns to your source table DateCreated and DateModified. first time you dump all the records from source to destination. later you can store the maxdate of datecreated column destination table somewhere and look for records that are added after that date in the source . sameway you […]
2003-06-19
1 reads
RE: Connection Dropping on with xp clients
It could be an MDAC issue. For instance there are known issues going from MDAC 2.5 to 2.6/2.7. What are the pre-XP and XP MDAC versions and service packs?
2003-06-19
RE: Security Methodology Using Roles
If you are really cracking down, then they should not be able to schedule jobs or alter packages. You are introducing places where change is not managed. Someone should approve a package change just like an object change. That being said, remove guest from msdb and ensure that their accounts are being used. You can […]
2003-06-18
1 reads
RE: User-defined fields
Recent post of same topic: http://qa.sqlservercentral.com/forum/topic.asp?TOPIC_ID=13248&FORUM_ID=49&CAT_ID=1&Topic_Title=Handling+%22optional+fields%22&Forum_Title=Strategies
2003-06-17
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers