Viewing 15 posts - 3,781 through 3,795 (of 6,041 total)
First, I'd suggest a column called ClosedDate. But until you scale up to several millions of rows, then partitioning your table(s) for the sake of performance is not worthwhile. However,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 8, 2015 at 11:55 am
Take a look at the CHECKSUM() and CHECKSUM_AGG() functions.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 8, 2015 at 11:39 am
If you want to know the salary of a specific US federal employee, someone has created a user friendly website using public data.
http://www.fedsmith.com/2013/04/29/locating-the-salary-of-an-individual-federal-employee/
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 8, 2015 at 9:06 am
Jeff Moden (6/8/2015)
Eric M Russell (6/8/2015)
Jeff Moden (6/8/2015)
Andy Warren (6/8/2015)
Jeff, would you decline an offer from a company that publishes all salaries?Yes.
Even if the company were financially stable, the IT...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 8, 2015 at 8:52 am
Jeff Moden (6/8/2015)
Andy Warren (6/8/2015)
Jeff, would you decline an offer from a company that publishes all salaries?Yes.
Even if the company were financially stable, the IT projects interesting, and the published...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 8, 2015 at 8:12 am
David.Poole (6/7/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 8, 2015 at 7:55 am
I can see a user looking up a [single] automobile using VIN, so it needs to be included, not null, and indexed; maybe even uniquely indexed. However, just like FirstName...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 8, 2015 at 7:25 am
I saw this the other day and thought it was kind of funny.
Man Celebrates Raise Company Will Eventually Use To Justify Firing Him
http://www.theonion.com/article/man-celebrates-raise-company-will-eventually-use-j-50485
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 5, 2015 at 2:58 pm
mwilliams4nc (6/5/2015)
So is it like this then?
tblVins
-------
VinID -- numeric -- Primary Key
Vin --...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 5, 2015 at 1:34 pm
Lynn Pettis (6/5/2015)
Eric M Russell (6/5/2015)
Andy Warren (6/5/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 5, 2015 at 12:18 pm
Andy Warren (6/5/2015)
Eric, I'd agree with that. But suppose there were two of you doing that. Same job, same skills. Virtual twins. Should they get paid the same?
Two of me...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 5, 2015 at 11:41 am
The way I see it, employees should be valued the same way realestate is valued. That is, employees should be valued based on their market scarcity and revenue generating potential....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 5, 2015 at 11:20 am
Keep in mind that your reporting tool can apply it's own sorting regardless of what ORDER BY clause is specified in the SQL query.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 5, 2015 at 7:33 am
By default, SQL Server maintains histogram type statistics on columns referenced in conditional expressions. When supplied with table and column name, the DBCC SHOW_STATISTICS command will return a grouping of...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 4, 2015 at 4:08 pm
The coworker who can successfully login, have them come by your desk, and then do the following using your PC.
While holding down Shift key, right click on the SSMS...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 4, 2015 at 3:19 pm
Viewing 15 posts - 3,781 through 3,795 (of 6,041 total)