Viewing 15 posts - 10,366 through 10,380 (of 11,678 total)
I would go to a session like this one.
I'm always eager to learn from more experienced people who have already learned from mistakes, so that I can avoid them 🙂
One...
January 20, 2011 at 1:25 pm
That is probably because the numbers you typed are using another data type behind the scenes (I guess float?) than the variables, which are of the numeric data type.
When using...
January 20, 2011 at 7:18 am
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
Viewing 15 posts - 10,366 through 10,380 (of 11,678 total)