Viewing 15 posts - 1,021 through 1,035 (of 19,560 total)
Revenant (8/4/2015)
Ed Wagner (8/4/2015)
bcsims 90437 (8/4/2015)
whereisSQL? (8/4/2015)
Ed Wagner (8/4/2015)
DonlSimpson (8/4/2015)
Eirikur Eiriksson (8/4/2015)
Ed Wagner (8/4/2015)
SQLRNNR (8/4/2015)
Revenant (8/4/2015)
Ed Wagner (8/4/2015)
bcsims 90437 (8/4/2015)
whereisSQL? (8/4/2015)
Ed Wagner (8/4/2015)
DonlSimpson (8/4/2015)
Eirikur Eiriksson (8/4/2015)
Ed Wagner (8/4/2015)
SQLRNNR (8/4/2015)
PrimeNumber
Act
Phone
Smart
y Pants
Where's...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 3:38 pm
Lynn Pettis (8/4/2015)
SQLRNNR (8/4/2015)
Steve Jones - SSC Editor (8/4/2015)
Is there value in getting the questions/knowledge that people lack in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 3:29 pm
kennyhuang0108 (8/4/2015)
Should I apply the whole thing or only below part in my query? thank you
SELECT LEV5
FROM MyCTE
GROUP BY LEV5
HAVING COUNT(*) > 1
)
SELECT MC.*
FROM MyCTE...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 3:28 pm
newbieuser (8/4/2015)
What are other causes that make check/FK constraints non trusted because we normally don't enable/disable constraints during loads or scripts or anything. We always drop and re-create...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 2:40 pm
WayneS (8/4/2015)
Sean Lange (8/4/2015)
yb751 (8/4/2015)
Sorry just needed two seconds to vent. :crazy:
I'm sure like anything else it can...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 2:33 pm
bghad1 (8/4/2015)
Alvin Ramard (8/4/2015)
FYI, there are many foreigners working in every imaginable IT position, including BI, in the US.
are you sure that BI is not kinda restricted area of IT...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 2:31 pm
sqlinterset (8/4/2015)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 11:45 am
kennyhuang0108 (8/4/2015)
Thanks Steve.When I added below part into my query
group by B.BF_ORGN_CD, B.LEV5, A.BF_ACTY_CD
having count(B.LEV5) >1
none of the records was showed. Not sure if I did something wrong.
thanks.
Try using...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 11:36 am
Prime
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 11:21 am
Steve Jones - SSC Editor (8/4/2015)
Is there value in getting the questions/knowledge that people lack in interviews published? Not...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 11:13 am
Cadavre (8/4/2015)
Cheat! 😛
Who me?:crazy:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 9:17 am
Are you trying to access the files from SQL via the UNC as well, and that is failing?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 8:39 am
Jeff Moden (8/4/2015)
Might have to add the 3 different WHERE clauses to that... they are all different.
Minor things. Who needs a correct filter (as I went back and fixed mine...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 8:37 am
Cadavre (8/4/2015)
Again, not very clear what you want. . . maybe something like: -
Look at that, getting lucky. 😀
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 8:33 am
sqlinterset (8/4/2015)
Can you share some really good articles?
I would start with the Stairway Series on SSIS by Andy Leonard.
http://www.sqlservercentral.com/stairway/72494/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2015 at 8:31 am
Viewing 15 posts - 1,021 through 1,035 (of 19,560 total)