Viewing 15 posts - 3,631 through 3,645 (of 19,560 total)
Jacob Wilkins (2/18/2014)
If it shows there's an active transaction, 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 18, 2014 at 9:07 am
Jeff Moden (2/18/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 18, 2014 at 9:06 am
TomThomson (2/18/2014)
Ed Wagner (2/18/2014)
BWFC (2/18/2014)
SQLRNNR (2/17/2014)
Ed Wagner (2/17/2014)
Revenant (2/17/2014)
TomThomson (2/17/2014)
SQLRNNR (2/17/2014)
hairdog
dachshund
Sausage
schnitzel
Noodles
Pasta
Arrival Theorem (Poisson arrivals see time averages)
langouste
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 18, 2014 at 8:07 am
Koen Verbeeck (2/17/2014)
The following operations cannot be performed on the model database:
...
Setting the primary filegroup to READ_ONLY.
Damn you MSDN!
Yeah that can be a bit misleading. The primary filegroup can't...
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 18, 2014 at 8:03 am
TomThomson (2/18/2014)
Koen Verbeeck (2/18/2014)
Hany Helmy (2/18/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 18, 2014 at 7:48 am
Do you have any other reason to believe you have/had a memory issue?
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 18, 2014 at 7:42 am
Gary Varga (2/18/2014)
paul.knibbs (2/18/2014)
SQLRNNR (2/17/2014)
the ability to protect the entire system is dependent on the weakest link
That needs to be underscored. No matter the system, there is a weakest...
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 18, 2014 at 7:40 am
What is your goal in trying to filter by somebody's First name?
Do you have sample data and table definitions to help solve this problem you are running into?
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 17, 2014 at 8:43 pm
the ability to protect the entire system is dependent on the weakest link
That needs to be underscored. No matter the system, there is a weakest link. Every network...
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 17, 2014 at 8:37 pm
FWIW = "For What it's Worth"
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 17, 2014 at 8:30 pm
If you want to filter for First Name, then you need to use [lev].[stringValue] in your where clause.
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 17, 2014 at 8:26 pm
Thanks for the question.
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 17, 2014 at 8:21 pm
paulaalkz 9229 (2/17/2014)
Thanks for all the replies. Disabling the account is definitely simple and perfect for my scenario. Thanks again.
Good to hear and glad you have a solution.
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 17, 2014 at 8:12 pm
Did you have service broker enabled?
It also sounds like maybe somebody had created a table and kept inserting tons of records into it. Find what table is the largest...
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 17, 2014 at 6:46 pm
try this and see if it works
SELECT *
FROM abc a1
INNER JOIN abc a2
ON a1.id = a2.id
AND a1.enterdate = a2.enterdate+1
AND a1.stat = a2.stat
WHERE a1.stat = 'Live'
AND a1.typo <> a2.typo;
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 17, 2014 at 6:35 pm
Viewing 15 posts - 3,631 through 3,645 (of 19,560 total)