RE: Checking SQL Server UPTIME
You might be able to write some logic using "DATEPART" to give you the individual components...
2005-03-02
r language
RE: Top N across groupings
you could do something like this but I'm sure there's a faster way to return that query... this takes 30 secs to run on 30 groupings / 10k rows)... however the indexes are not optimized (90% of the work is done on scans and bookmark lookups). Select XType, id, name from dbo.ObjSQL O1 where PkObjSQL […]
2005-03-01
RE: SELECT TOP 1 cannot work in Partitioned View?
BTW, anyone knows how to submit a bug report to Microsoft?
2005-02-28
RE: DBROCESS is dead or not enabled Error - Please Help
I agree with Phil in that it sounds like your network conneciton is being dropped at some point. I saw this error a couple of years ago with a Sybase app and fixed it by updating the client ODBC components. Are you using the version of MDAC specified by the vendor on the clients?
2005-02-24
RE: SQL Syntax question
I took out your variable for my testing so you will need to add it back in... Anyway, I think this does what you need - eventhough it is extremely ugly. I would keep looking for a better way to do it. I don't think this will be very effecient.SELECT r.year, r.qtr, r.industry_code FROM rpt_calc_data […]
2005-02-21
RE: Gmail Invitations!
Hi,I'd like a gmail invite.Thanks for the offer.Have a great day,Steve Morrowsmorrow@hickorytech.net
2005-02-18
RE:
i am writing to apply for DBA post advertised in Florida, I completed my associate degree (Diploma) in Computing.I have been working as Programmer/DBA for 8 months at Agriculatural bank of Namibia, and would be happy for job.
2005-02-18
2 reads
RE: IIS connecting to SQL licensing
Unless you can identify each client that will consume (not necessarily directly access) SQL Server you need to go with "Per processor" licensing. http://www.microsoft.com/sql/howtobuy/multiplexing.aspGenerally this is difficult to do when the clients access SQL through IIS or some sort of middleware layer.
2005-02-17
How to find is SP1 installed or not for reporting services?
How to find is SP1 installed or not for reporting services?TIA
2005-02-17
RE: Insert INTO Fails ???
Both IN clause and EXISTS clause are giving same error if I copy the statement the way it's written in the post. I will see if I need to modify it.Thanks.
2005-02-17
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