Viewing 15 posts - 511 through 525 (of 2,452 total)
Dreckly.
wonder how many other people here know the meaning of that 😛
July 11, 2016 at 1:15 pm
July 11, 2016 at 1:06 pm
ChrisM@Work (7/11/2016)
J Livingston SQL (7/11/2016)
ChrisM@Work (7/11/2016)
Assuming you're in a playpen, CHECKPOINT then dbcc dropcleanbuffers. You might free up a few kb 😀
I'll tell you what I'll do Chris......as its only...
July 11, 2016 at 10:21 am
ChrisM@Work (7/11/2016)
Assuming you're in a playpen, CHECKPOINT then dbcc dropcleanbuffers. You might free up a few kb 😀
I'll tell you what I'll do Chris......as its only a home laptop that...
July 11, 2016 at 10:05 am
ChrisM@Work (7/11/2016)
J Livingston SQL (7/11/2016)
== CJM2 ==========================================================================Table 'testtable'. Scan count 9, logical reads 24440, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead...
July 11, 2016 at 9:53 am
== CJM2 ==========================================================================
Table 'testtable'. Scan count 9, logical reads 24440, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Worktable'. Scan...
July 11, 2016 at 9:13 am
It's quick G but not quite as quick as this, which uses no Black Magic at all:
I dont get the same results Chris....any thoughts ??
PRINT '== IBG =========================================================================='
SET STATISTICS...
July 11, 2016 at 7:24 am
ChrisM@Work (7/11/2016)
IBG's first query looks like this:
SELECT code, startdate AS...
July 11, 2016 at 6:36 am
Basically, I would like take these 10 records and create each item (inventory) or each day of the year.
thanks for the sample data...appreciated....but I think that you now need to...
July 9, 2016 at 1:38 pm
rjjh78 (7/9/2016)
Hello,I am working on a database and would like to create a script that would auto-generate 1,2,3, or 5 years of data in one run.
in answer to...
July 9, 2016 at 1:23 pm
rootfixxxer (7/9/2016)
ThanksCame from the 2005 version, and didnt know this functions...
"every day is a school day " 🙂
glad to be of help
July 9, 2016 at 10:27 am
durga.palepu (7/9/2016)
How to do that pointing?
seems like Jeff has already "wyafy" 😛
Jeff Moden (7/9/2016)
July 9, 2016 at 9:47 am
rootfixxxer (7/9/2016)
The topic name it isn't the best, but it's what i need.
So i have a list of times from a race, i need to order the athletes to show,...
July 9, 2016 at 9:25 am
Viewing 15 posts - 511 through 525 (of 2,452 total)