Viewing 15 posts - 10,366 through 10,380 (of 11,676 total)
In your second example, why is only the first row to be returned?
According to your logic, the second row should also be returned, since there is also no match at...
January 20, 2011 at 7:12 am
Although not really applicable to me (right now), I still enjoyed the article.
Good work!
January 20, 2011 at 7:04 am
GSquared (1/20/2011)
Or short-circuit the whole thing, start calling yourself a "Microsoft NVP" (Not-Quite As Valuable Player), and see how many people think it's just a typo.
That one is worth remembering...
January 20, 2011 at 6:48 am
saurabh.deshpande (1/20/2011)
Koen (da-zero) (1/20/2011)
But normally, I would expect parallellism to win. Just make sure no locks are introduced.
Also, be aware that...
January 20, 2011 at 6:47 am
Brandie Tarvin (1/20/2011)
Raunak Jhawar (1/20/2011)
Cube wizard will just provide a "doable" structure. Good for learning. Cannot be used for live systems/projects 🙂
I'm curious. Why do you say it can't be...
January 20, 2011 at 6:40 am
Brandie Tarvin (1/20/2011)
Koen (da-zero) (1/20/2011)
SSAS doesn't add the dimension itself to the cube, unless you used the cube wizard.
I did use the cube wizard. That's what was so frustrating. No...
January 20, 2011 at 6:38 am
The most basic solution is using the sp_send_dbmail stored procedure.
Read the contents of the Excel with an OPENROWSET query and e-mail the results directly to the recipients.
A more flexible approach...
January 20, 2011 at 5:31 am
It kind of depends on how much processors you have.
But normally, I would expect parallellism to win. Just make sure no locks are introduced.
Also, be aware that high parallellism can...
January 20, 2011 at 5:27 am
Brandie Tarvin (1/20/2011)
I saw a job description once that very specifically asked for 5 years experience in SQL 2005.That was in May of 2005.
So they were specifically targetting the SQL...
January 20, 2011 at 5:25 am
You can probably schedule a lot with windows task manager, but using jobs you can define flexible schedules, you have integrated logging and notifications, you can implement restartability and so...
January 20, 2011 at 5:22 am
Is this what you're looking for?
http://sqlserverplanet.com/security/add-users-to-database-script/
(don't know if it works properly, I just did a quick google search)
January 20, 2011 at 5:19 am
Make sure that the date format used in Excel is compatible with the one used in SQL Server.
For example: mm/dd/yyyy versus dd/mm/yyyy
When it is the first one, 20/01/2011 will give...
January 20, 2011 at 3:32 am
katesl (1/20/2011)
I have to ask this question because I have no experience doing user interface programming-- I use T-SQL and SSMS, and Excel to deliver reports, for...
January 20, 2011 at 3:18 am
Whupty-freakin'-doo! This is an amazing article!
I have never heard of DATENAME before, so thanks for pointing it out Jeff.
January 20, 2011 at 3:09 am
I was real sad to see Donald Farmer leave MS BI.
I just saw him speak at an event at early december 2010, which isn't really a long time ago.
He had...
January 20, 2011 at 2:58 am
Viewing 15 posts - 10,366 through 10,380 (of 11,676 total)