Viewing 15 posts - 6,211 through 6,225 (of 9,643 total)
Wow, there's a lot going on there, the first thing I did was eliminate thee first 3 derived tables (the select *'s without any where clauses).
There isn't anything that...
January 19, 2009 at 8:34 am
What do you mean by more functionality? The DBEngine isn't going to do more because you are using the full-blown management tools. If that happened, then there would...
January 19, 2009 at 7:20 am
Grant Fritchey (1/19/2009)
Ninja's_RGR'us (1/19/2009)
That's worth repiting Grant :w00t::D:hehe:.
What? Did the copy editors fall down on the job again. Steve, fire that mangy lot and get someone decent in here to...
January 19, 2009 at 7:17 am
You have asked for specific answers to general questions. Please see the links in my signature.
January 19, 2009 at 7:10 am
Based on what I have read in BOL, you need to have an explicit COMMIT TRANSACTION.
A user can set a savepoint, or marker, within a transaction. The savepoint defines a...
January 19, 2009 at 7:08 am
Since it is MSDE I don't believe you need any CAL's to connect to the SQL Server.
January 19, 2009 at 6:55 am
I don't have 2000 installed currently, but you can change the timeout settings in Tools -> Options.
January 19, 2009 at 6:44 am
If you are using SSIS then the lookup component is the current method to do this. If the databases are on the same server you could get better performance...
January 19, 2009 at 6:35 am
mamsay (1/18/2009)
writting data into excel sheet doesn't work.. so now i changed my proceedings.. it is throwing many errors.. i think writing the excel sheet through scheduling is not...
January 19, 2009 at 6:27 am
Definitely try to solve this with a set-based solution. Cursoring through 200,000 rows will kill the server. If you post your DDL and some sample data (see the...
January 19, 2009 at 6:23 am
Here's a good blog post about people just implementing solutions form the internet or forums without caring why:
http://www.straightpathsql.com/blog/2009/1/18/empirical-evidence.html
I found this on a tweet by Jonathan Kehayias.
January 19, 2009 at 6:08 am
Vadim Rapp (1/19/2009)
Jack Corbett (1/16/2009)How would SQL Server authenticate the user?
How about this
So it can be done, but don't miss this line:
Both methods are not recommended.
January 19, 2009 at 6:03 am
Who knows how good it will be? I have a basic outline of the "series" it is based on a Profiler presentation I did at the Orlando User Group...
January 18, 2009 at 6:26 pm
I've got a series on Profiler/Trace in process, building from real basic to a little more advanced (server-side traces, etc...). I was waiting on getting a new laptop, done,...
January 18, 2009 at 2:33 pm
Viewing 15 posts - 6,211 through 6,225 (of 9,643 total)