Viewing 15 posts - 1,891 through 1,905 (of 3,658 total)
So a bit value is 1 or 0
A date is 20110728
A Money value is 65000
If money is a whole value then why not use an INT?
If money is a decimal...
July 27, 2011 at 2:23 pm
What proportion of reads do you have to writes?
Can you subdivide what you do along a product line basis?
Can you break your database out into separate DBs for customers, products...
July 27, 2011 at 2:10 pm
The InnoDB engine has a default page size of 16K which is global to the engine.
The MySQL web site says you can recompile the code to anything between 4K and...
July 27, 2011 at 1:00 pm
If you accept the premise that your surrogate keys are going to be BIGINT values then you could try the following
The right most 6 characters are just a sequential number
The...
July 25, 2011 at 4:01 pm
Any views or procs that reference objects in your CONFIG database?
anything that uses cross database ownership chaining?
July 24, 2011 at 12:55 pm
What exactly are you trying to achieve?
Are you attempting to come up with some sort of key generator?
Whereas a uniqueidentifier is 16 bytes a bigint is 8 but random keys...
July 24, 2011 at 12:49 pm
This would be on my list of things to avoid.
The nearest I've seen to a "safe" solution was where the tables for which these actions were allowed were stored in...
July 24, 2011 at 11:49 am
It's taken me a long time to wean myself of querying sysobjects, using GETDATE() etc.
I'm finding I'm dealing with disparate data sources so focussing on ANSI standard commands does eventually...
July 24, 2011 at 11:32 am
Do you actually use the XML datatype within SQL Server for anything other than the storage of XML data?
What I am getting at is if all you want to do...
July 24, 2011 at 11:18 am
I take it your DOMAIN\Administrator account has permissions to both SQL Server and the file system where the replication snapshot files are kept?
Just asking because some places block network and...
July 24, 2011 at 11:14 am
When I'm interviewing people all my questions can be attributed to 3 meta-questions
1. Can they do the job
2. Will they do the job
3. Will they fit in.
The...
July 20, 2011 at 4:30 pm
The endless pursuit of cheaper goods strikes me as a typical case of propping a ladder against a branch then sawing the wrong side of the ladder!
In the UK some...
July 17, 2011 at 6:29 am
I'm working on a large data warehouse project so data quality issues are my world at present.
Data quality in any shape or form is everyones responsibility. It doesn't matter...
July 14, 2011 at 8:14 am
Oil is cheaper than engines:hehe:
Cleaning out your trunk/boot will save you fuel because you aren't lugging a lot of dead weight around. Get those purge/archive strategies defined.
Keep it clean...
June 29, 2011 at 2:49 pm
I tend to evaluate sites over time. Some authors I learn to trust, others I use to provoke thought.
In general I look for articles that give examples. In...
June 28, 2011 at 3:16 pm
Viewing 15 posts - 1,891 through 1,905 (of 3,658 total)