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,...
June 8, 2015 at 11:55 am
Take a look at the CHECKSUM() and CHECKSUM_AGG() functions.
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/
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...
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...
June 8, 2015 at 8:12 am
David.Poole (6/7/2015)
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...
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
June 5, 2015 at 2:58 pm
mwilliams4nc (6/5/2015)
So is it like this then?
tblVins
-------
VinID -- numeric -- Primary Key
Vin --...
June 5, 2015 at 1:34 pm
Lynn Pettis (6/5/2015)
Eric M Russell (6/5/2015)
Andy Warren (6/5/2015)
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...
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....
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.
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...
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...
June 4, 2015 at 3:19 pm
Viewing 15 posts - 3,781 through 3,795 (of 6,041 total)