RE: Assign date in VB Script (DTS)
Plese, verify the data format before convert.You can explicit the format for data in convert clause.
2005-02-14
productivity
RE: Crystal Reports data access methods (stored procs, etc.)
Option A also keeps your logic out of the report, which turns the report into just a formatting tool. This allows other tools, such as excel, to use the same source logic, which enhances reuse and makes reconciliation easier. This will also allow you more easily to switch to a different tool if needed. Example: Crystal […]
2004-11-05
RE: Cannot Register an Instance of SQL Server 2000
Hi rmizzar!It might be caused by what protocols that are used. I would try to first set the language to tcp/ip and if that does not work, to named pipes.If you are logged in on the server when you do this, use the Client Network Utility and go to Aliases tab. Type in the servername […]
2004-07-28
RE: Sargable condition slower than non-sargable...why?
your problem was more interesting than my work..... I can tell you the exec-plans are different....print them out and compare line by line....you'll see they diverge quite fast.i'd be interested to see if the exec-plans (of both queries) from the test box...(which are always fast???)...differ in any way....either between themselves...or compared to the prod versions.
2004-07-22
RE: Returning too many rows....
hey egnagey,try adding the following HAVING clause to your SQL to see if that is what you are looking for:SELECT tblroofs.roofid, cap.estimatedcost as CapCost, cap.estimateddate FROM tblcapitalexpenditures as cap RIGHT OUTER JOIN tblroofs ON cap.RoofID = tblRoofs.RoofID WHERE [tblRoofs].[CompanyID] = @CompanyID AND DATEPART(yyyy, cap.estimateddate) >= DATEPART(yyyy, DATEADD(yyyy, 1, GETDATE())) GROUP BY […]
2004-07-22
RE: A tale of two where clauses...
Run them in Query analyser with the execution plan enabled, see where the difference lies
2004-07-22
RE: Where Can I find Yukon Beta?
I searched whole of MSDN and its release contents online but couldn't find it. I also suspected for release label as SQL Server 2005 but there was none. Usually MS releases beta products for MSDN enterprises? Can Yukon be a exception? That would be against MS marketing policy Please let me know if you come across […]
2004-04-09
RE: clustering
When implementing a 4node cluster, you may also consider your OS. I think Win2K Advanced Server supports only up to 2node. You have to go to Datacenter to implement a 4node.
2003-06-23
RE: clustering
your post is pretty generic. Are you saying you have two databases - running on the same SQL Server - that you want to have running at the same time? If so, An Active/Passive cluster of 2 nodes will work fine - and is the cheaper of the 2 scenarios you mentioned. Of course, this […]
2003-06-23
RE: clustering
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
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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