Viewing 15 posts - 16 through 30 (of 68 total)
One more case when optimizer is not able to decorrelate subquery is an assert impact.
Interesting! so what is a scenario when the optimizer compiles both a correlated subquery query and...
October 26, 2012 at 10:15 am
However, sometimes the SP's get updated on the Production Server. What I want is that those updates are copied automatically to the Report Server. Once a day, for example in...
October 26, 2012 at 8:26 am
looks like im off to hit the books on correlated subqueries now. then go yell at the guy i heard it from.
+1 to that...
Could've swore I've read in...
October 26, 2012 at 3:24 am
Please suggest what could be the reason for same and if there is a possibility we can fix this without restarting sql server
Hi,
I have experienced this in the past for...
October 25, 2012 at 7:19 am
kk.86manu (10/25/2012)
Unfortunately i am still not able to do this.Please see the details below
Scenario:
I have a login test_login which has role as db_datareader and db_datawriter.
Created this stored...
October 25, 2012 at 5:09 am
The user has permissions to execute the stored procedure.The stored procdure is having CREATE,ALTER TABLE, ALTER PARTITIONS statements in it?
Just to clarify, these are DDL statements and not DML.
October 25, 2012 at 4:58 am
:blush:
Thanks for taking the time to answer my post Brent.
The resources you provided look very interesting. Definitely bookmarked!
Personally I do enjoy SQL material delivered through video, in fact I tend...
October 24, 2012 at 5:05 pm
SQLCrazyCertified (10/23/2012)
October 23, 2012 at 2:18 pm
Luis Cazares (10/23/2012)
There's no need to create a view. You'll end up with millions of views that you won't use.
+1
or even use a CTE.
October 23, 2012 at 12:19 pm
icata (10/23/2012)
Something like thisselect join_alias.col11, join_alias.col21 from
(table1 a INNER JOIN table2 b ON a.col11=b.col21) join_alias
Hope it makes sense.
Please let me know.
Don't think it exists in a format similar to the...
October 23, 2012 at 11:42 am
kmiles (10/21/2012)
October 21, 2012 at 12:47 pm
lonhanner (10/21/2012)
I have several tables and need to set relationships. How do you do this with the sql server manager?
Here is an article on creating foreign key relationships in SQL...
October 21, 2012 at 12:36 pm
Abu Dina (10/19/2012)
I opened the package in NotePad++ but when I search for the variable it's not there!This is just typical SSIS bull$h!t.
Hmm strange, only other thing I can think...
October 19, 2012 at 8:03 am
Abu Dina (10/19/2012)
I will keep trying and see what...
October 19, 2012 at 7:46 am
Maybe I'm missing something but is there a way to make SSIS display all variables used?! The package does contain a lot of components so maybe I've missed one somewhere...
October 19, 2012 at 6:42 am
Viewing 15 posts - 16 through 30 (of 68 total)