Viewing 15 posts - 676 through 690 (of 716 total)
When do you think part 3 will be ready?
May 14, 2010 at 5:26 pm
CirquedeSQLeil (5/14/2010)
What your locales set to in SQL Server.
Do you mean the collation? If so that is: SQL_Latin1_General_CP1_CI_AS
May 14, 2010 at 5:24 pm
I could use your method of casting all of the values, but it would make for some pretty ugly code, both in Access and SQL.
If Access runs the query directly...
May 14, 2010 at 5:20 pm
I think this was a good question, but the title "Careful with table name alias" sort of gave everything away.
May 14, 2010 at 9:45 am
Great question and learned a couple things in the process, a very good start to a day.
Thanks!
May 13, 2010 at 10:03 am
sknox (5/12/2010)The question was good, but had a minor flaw in presentation. Because it was single-choice, and the two relevant choices were Standard and Enterprise edition, all that was required...
May 12, 2010 at 9:46 am
I missed it just because of the physical order part... They are physically stored in the clustered order, maybe just not contiguously/in sequence. The BOL docs don't help much.
May 6, 2010 at 11:43 am
Great question, gets you to actually thinking about what SQL Server is doing in the background.
May 5, 2010 at 4:50 pm
Solomon Rutzky (5/4/2010)
May 4, 2010 at 10:16 am
What happens if you use a sub query to get the minimum value for each partition, and then get the min of that?
i.e. Something like this:
SELECT MIN(MinIntDate)
FROM (SELECT PartitionID, MIN(IntDate)...
May 4, 2010 at 9:54 am
matt stockham (4/20/2010)
You can use 'TRUE' and 'FALSE' as quoted strings - http://msdn.microsoft.com/en-us/library/ms177603.aspx
Matt,
Thanks for some reason I never saw that, I think that will help make some code more readable.
April 20, 2010 at 1:43 pm
Thanks Wayne, I had been meaning to investigate the ranking/window functions but hadn't gotten the time yet. Your article with the clear examples made it a cinch to understand the...
April 20, 2010 at 10:18 am
Paul, Wow, thanks for these two articles they really helped me understand better use of APPLY. Now if I can just remember all of that I think I will use...
April 19, 2010 at 3:52 pm
Jerry Hung (11/19/2009)I fixed all maintenance plans and jobs on 20+ servers in 1 run
Not quite that easy, I think you still have to manually change, save, change back,...
November 19, 2009 at 10:20 am
You really want all jobs owned by SA? Doesn't that sort of eliminate any idea of security? If a developer wants to change something they don't have permission for they...
November 19, 2009 at 10:14 am
Viewing 15 posts - 676 through 690 (of 716 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy