Viewing 15 posts - 3,736 through 3,750 (of 19,560 total)
twin.devil (2/12/2014)
very good question for the beginners to understand what OR , AND does.Thanks for sharing ..
Yes - and even for the experienced to remind them of the order of...
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
February 12, 2014 at 7:46 am
Ed Wagner (2/12/2014)
BWFC (2/12/2014)
whereisSQL? (2/11/2014)
SQLRNNR (2/11/2014)
Lynn Pettis (2/11/2014)
Seventh Heaven! (All this delicious food!!)Cloud 9
ecstacy
Agony
Pain
Gain
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
February 12, 2014 at 7:44 am
Cool beans. Glad it is straightened out.
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
February 12, 2014 at 7:40 am
pmadhavapeddi22 (2/12/2014)
I have re written the query by joining the de norm table in from clause, but the no of
reads and cpu are high with the new query. Old query...
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
February 12, 2014 at 7:39 am
That's a job that I would look to tune right away.
Is it possible that some job out there could realistically run that long? Sure. But it depends on...
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
February 11, 2014 at 9:47 pm
Lokesh Vij (2/11/2014)
An easy one for the day. Thanks Steve 🙂
Agreed - thanks Steve
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
February 11, 2014 at 9:37 pm
So you shared the portion of the script to add a login to a role. But what about the portion to grant the login access to the database?
When you...
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
February 11, 2014 at 9:28 pm
Lynn Pettis (2/11/2014)
Seventh Heaven! (All this delicious food!!)
Cloud 9
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
February 11, 2014 at 9:18 pm
Yeah that is bizarre. Something must have short circuited that select at the time the backup was running. I haven't seen that happen before with this kind of...
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
February 11, 2014 at 9:16 pm
phegedusich (2/11/2014)
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
February 11, 2014 at 7:26 pm
Revenant (2/11/2014)
whereisSQL? (2/11/2014)
SQLRNNR (2/11/2014)
long (as in this quote string is too long and starting to mess up the formatting)integer
[get] real 😉
float
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
February 11, 2014 at 7:22 pm
I wonder if for some reason those database names are not selecting out of the sysdatabases and thus creating the failure.
What is the result of your select query that populates...
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
February 11, 2014 at 7:22 pm
Jeff Moden (2/11/2014)
pmadhavapeddi22 (2/11/2014)
Sorry for the late reply,
continuation of the above topic...
As you asked, the below is one of the update statements we are using in stored procedure
Update de_norm_buscard_attr...
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
February 11, 2014 at 5:09 pm
Lynn Pettis (2/11/2014)
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
February 11, 2014 at 4:39 pm
Lynn Pettis (2/11/2014)
Also look to see if there is a local SQL Server Users Group in your area. Good place to make contacts as well.
Good point Lynn
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
February 11, 2014 at 4:34 pm
Viewing 15 posts - 3,736 through 3,750 (of 19,560 total)