Viewing 15 posts - 511 through 525 (of 2,452 total)
Dreckly.
wonder how many other people here know the meaning of that 😛
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 11, 2016 at 1:15 pm
nope
http://ark.intel.com/products/88195/Intel-Core-i7-6700K-Processor-8M-Cache-up-to-4_20-GHz
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 11, 2016 at 1:06 pm
sql restarted
10 runs each
comment ms
CJM2 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 11, 2016 at 12:00 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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 11, 2016 at 10:05 am
ChrisM@Work (7/11/2016)
J Livingston SQL (7/11/2016)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 11, 2016 at 9:13 am
guess I am !!
only 12 GB here
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 11, 2016 at 7:37 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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 11, 2016 at 7:24 am
ChrisM@Work (7/11/2016)
IBG's first query looks like this:
SELECT code, startdate AS...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 9, 2016 at 9:25 am
Viewing 15 posts - 511 through 525 (of 2,452 total)