RE: QOD - RAM available to SQL 2000 Standard
Does this mean SQL Server Engine will use upto 2GB RAM for its usage and leave the excess memory for OS and other apps (if there is more than 2GB on server).
2003-06-30
1 reads
split
RE: Server Upgrade / Migration
Yep again, I attempted a single user mode restore and it went belly up because it didn't like the fact that the user database weren't where they were expected. The server refused to start so I decided to back out of that strategy. I actually posted the same comments to the Microsoft partner newsgroups and […]
2003-06-25
RE: Dynamic Views
Personally I'd write multiple views to cover the possibilities. How often would they change? If it's not that often (you have to judge that), I'd then just hit the right view. Might seem like more work, but probably would run better. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-19
1 reads
RE: group by part of a multi column primary key
I may be over-simplifying this, but: SELECT col1, Max(col2) FROM t1 GROUP BY col1 --SJTerrill Ah, I'm definitely over-simplifying. I believe you'll have to resort to subquery to return the contents of the whole row. Edited by - TheWildHun on 06/12/2003 12:49:27 PM
2003-06-12
2003-06-04
RE: Select statement
Give us an example of the data including things you wouldn't see. From that what you expect to be returned and how you determine that is what you want. That will give us a better idea as to how to help.
2003-05-27
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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