I'd script from EM. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-19
We feel the issue is that SQL Server doesn't recognize SID History as other resources do. I think there is something that can be installed on SQL Server that makes it AD aware. Does anyone know what this contains? Edited by - Lee Forst on 11/26/2003 1:31:16 PM
2003-11-26
Make sure you are not trying to re-create the table when it already exists from the first time you ran the package.
2003-08-21
Hi a5xo3z1, I use no tools other than Query Analyser and a small stack of TSQL books from Amazon for the application programming. I agree that the Upsizing Wizard to get the initial data across is the first thing, that takes about a day, then the real work follows. You can copy some Jet Sql […]
2003-08-20
Never mind. I oversimplified, and once I noticed it's obvious. The view is actually select IsNull(t1.a,t2.a) as a, etc. so the where clause for the view isn't making it back through the IsNull where the optimizer knows it can deal with it.
2003-08-10
You made a good point about designing in the visual tool and then refining in QA. That's exactly what I'd like to do in EM only the capability is lacking for joins. That is the part that I can't figure out. Access is exceptional in this area. Same company, differing quality in product... As for […]
2003-07-25
quote: You can stay, Frank. I just get queezy when I see the words "Upsizing Wizard". Well, it was just your wording. My wife use to say something very similar, before putting my head in the right place again. . So, every time I hear this, it's high time to be sweet. Now, getting serious […]
2003-07-25
1 reads
You need to have some kind of data that shows where you are. If there is an ID, select and order by ID. The next select has a WHERE clause > the max ID of the last set. Same would be true of a Date field. If you don't have either of these, you need […]
2003-07-15
Stored procedures are much more maintainable, require less network traffic to transmit commands, and allow permissions to be more finely controlled. Just make sure you put together some sort of Source control for your procs.
2003-07-15
1 reads
2003-07-14
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers