Ok I am a proponent (big word for the day) ok stored procedure grouping. There biggest advantage are to break out code so that individual execution plans can be stored for situation many folks do if begin code here end else begin alternate code here end but to call that limited revisioning is not correct. […]
2003-11-17
Hi SQLBill, Actually, your example would return 1,2,2 in both cases. An example that would demonstrate WITH TIES is only slightly different: SELECT TOP 2 * FROM data ORDER BY numbers ASC numbers ----------- 1 2 compared with: SELECT TOP 2 WITH TIES * FROM data ORDER BY numbers ASC numbers ----------- 1 2 2 […]
2003-08-04
The error ocurrs the moment I attempt to select a source from the drop down list. Rusty
2003-07-29
Thats strange. I was going to suggest that you don't have privileges, but if that were the case then you wouldn't be able to use the MP wizard. What fixed server roles are you a member of?
2003-07-24
Antares, is this what you use? This is what our dba uses as well and every once in a while the CPU peaks between 85 and 95% and so the developers get asked the famous question of what changed today from yesterday. Sometimes the dba can pinpoint where the blocking is occurring but a lot […]
2003-07-24
And remember if you have an SS2k with a setting other then U.S. English, you have to verify that DATEPART for Friday actually is 6. See BOL 'DATEFIRST': quote: -- SET DATEFIRST to U.S. English default value of 7. SET DATEFIRST 7 GO SELECT CAST('1/1/99' AS datetime), DATEPART(dw, '1/1/99') -- January 1, 1999 is a […]
2003-07-24
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-07-11
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-07-03
Hi Dale, quote: Whatever happened to those ERDs (for Frank, Entity Relationship Diagrams) and UML (Universal Modeling Language) Class Diagrams? please, don't make me think, I'm the only one who doesn't understand. But I'm glad to see you care In fact, when it comes to slang or off-oxford english, which is tought in school here, […]
2003-06-25
quote: folks, thanks for all the suggestions.aye, I knew that this was going to be a bit hairy, but now i can make an informed decision.I will take a few days to get my head round this, and post a short review of what I did.Please feel free to laugh and or comment 🙂 i […]
2003-06-25
2 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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