Viewing 15 posts - 14,116 through 14,130 (of 22,227 total)
Stefan Krzywicki (10/14/2010)
Kit G (10/14/2010)
Stefan Krzywicki (10/14/2010)
They have color e-ink now, it just isn't in commercial devices yet. There was a Sci-Am article about it a year or so ago.
Neato!...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 14, 2010 at 9:36 am
Alvin Ramard (10/14/2010)
Steve Jones - SSC Editor (10/14/2010)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 14, 2010 at 9:33 am
Another way to generate procedures, that many people don't take advantage of, is to use the Templates offered by SSMS. If you click on the View menu and then Template...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 14, 2010 at 6:20 am
If it's two really distinct entities, then, yeah, I agree with everyone else, two tables. From the names you gave, Sponsor & Offer, it sure sounds like two distinct entities....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 14, 2010 at 6:09 am
Alvin Ramard (10/13/2010)
Grant Fritchey (10/13/2010)
Alvin Ramard (10/13/2010)
Has anyone here tried reading a pdf format ebook on a Kindle3? I'm thinking about getting a Kindle...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 14, 2010 at 5:52 am
Alvin Ramard (10/13/2010)
Has anyone here tried reading a pdf format ebook on a Kindle3? I'm thinking about getting a Kindle and I'm just wondering...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2010 at 2:08 pm
Brandie Tarvin (10/13/2010)
Grant Fritchey (10/13/2010)
I only agreed to write the book so I could say I was right about everything.Grant, Dude!
I didn't know you were a science fiction author. @=)
I'll...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2010 at 12:56 pm
The LOOP join is a hint where they're trying to force a choice on the optimizer. In addition to fixing the scan, I'd test taking out that hint to see...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2010 at 11:29 am
Stefan Krzywicki (10/13/2010)
Alvin Ramard (10/13/2010)
Celko strikes again.What an ***.
Can we just respond to all his posts with "Just because someone wrote a book doesn't mean they're right"?
Whoa! Wait a minute....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2010 at 11:27 am
Although, if you need to insert values into a table that has an identity column, you can make it possible using IDENTITY_INSERT
SET IDENTITY_INSERT myschma.mytable ON
Just remember to set it to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2010 at 8:19 am
If you haven't looked at the execution plan, you really need to. When you don't know what's happening with a query, that should be your first stop.
Also, be very, very...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2010 at 6:57 am
I'm OK with the xxx part. Sorry that was just meant to designate '*' or 'whatever' or 'fillintheblank.' My only exception was with the Hungarian notation on table names.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2010 at 6:49 am
I don't know how Access is calling this, but the TSQL command has correct syntax and should work. You might want to schema qualify the tables to ensure that you're...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2010 at 6:20 am
If the function is embedded in other statements you'll probably need to generate the list of places where it's used and then run the server-side trace as Gail suggested, looking...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2010 at 6:16 am
Oh please no, not tables named TBxxx. That's just so 1992 (not to mention, very, very Access). Surely, at this point in history, we can simply name a table, or...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2010 at 5:35 am
Viewing 15 posts - 14,116 through 14,130 (of 22,227 total)