Viewing 15 posts - 436 through 450 (of 477 total)
Phil Parkin (9/14/2015)
I would recommend that you create a calendar table[/url] and create a left join from your calendar table to the table which contains data.
Any mileage in looking for...
September 14, 2015 at 1:21 am
robinwilson (9/13/2015)
September 14, 2015 at 1:18 am
We store all our Sprocs, Triggers, Views etc. in separate files, and those are stored in a Revision Control System - SVN in our case, but I'd like to upgrade...
September 13, 2015 at 9:16 am
robinwilson (9/13/2015)
I cannot see the SQL in the software to see if they use NOLOCK
SQL Profiler, with filters on TextData for %NOLOCK% ([perhaps also a filter on Database Name, although...
September 13, 2015 at 5:03 am
Same concept as Eirikur but here is an alternative for the inline tally table. It doesn't seem to hurt performance to define all the "passes" up to 4,294,967,296 if you...
September 13, 2015 at 4:10 am
robinwilson (9/12/2015)
I recently moved to a new organisation and one of my first tasks was to work out why ...
You are probably already aware of it, but in case not...
September 12, 2015 at 7:38 pm
robinwilson (9/12/2015)
Is there a valid reason to use only heap tables
Only reason I know of is where the insert rate is astronomic. Even then lacking a Clustered Index can cause...
September 12, 2015 at 7:20 pm
subramanyammaruthi (9/12/2015)
And what is this below query used for?SELECT column_name as 'Column Name', data_type as 'Data Type',
character_maximum_length as 'Max Length'
FROM information_schema.columns
WHERE table_name = 'tblUsers'
Try running it ... if 'tblUsers'...
September 12, 2015 at 4:29 am
Would Log Shipping help? (although I think that might be deprecated in SQL2014 ?)
September 12, 2015 at 3:19 am
Previously I was hoping that it was hi-lo, e.g. YYYYMMDD HHMMSS.SSS, so although changing was being moved "close by" in the index page and would be self correcting as maybe...
September 12, 2015 at 3:14 am
erichansen1836 (9/11/2015)
... run the the JetComp.EXE compress/repair utility on a *.MDB Jet 4.x file, the file is re-optimized for query speed
Is that an "online" task? or an exclusive one? ...
September 11, 2015 at 11:52 pm
Jeff Moden (9/11/2015)
What format is that column stored in?
I'm guessing again ... but a normal GPS message starts with a code (which might not change) immediately followed by the time...
September 11, 2015 at 11:09 pm
Ed Wagner (9/11/2015)
Jacob Wilkins (9/11/2015)
I'll look into it when we do our next installation, which will hopefully be soon.
We turned on COMPRESS as the default (when we upgraded to a...
September 11, 2015 at 10:45 pm
Sean Lange (9/11/2015)
September 11, 2015 at 10:39 pm
Sean Lange (9/11/2015)
Kristen-173977 (9/11/2015)
September 11, 2015 at 11:37 am
Viewing 15 posts - 436 through 450 (of 477 total)