Viewing 15 posts - 2,971 through 2,985 (of 19,560 total)
Have you tried re-registering your spns for the sql boxes?
In addition, have you tried the steps in this article?
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
May 29, 2014 at 3:18 pm
temisola1 (5/29/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
May 29, 2014 at 3:10 pm
Sean Lange (5/29/2014)
SQLRNNR (5/29/2014)
Sean Lange (5/29/2014)
SQLRNNR (5/29/2014)
Sean Lange (5/29/2014)
Luis Cazares (5/29/2014)
JOIN keywords on the right of the tables.
+1000 That one drives me nuts!!! (ok I know it is a short...
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
May 29, 2014 at 3:06 pm
So you have a 4yr degree and 4 yrs of IT experience at the age of 19?
Here in the states, that would be questioned quite a bit.
Kudos to you if...
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
May 29, 2014 at 3:03 pm
Sean Lange (5/29/2014)
SQLRNNR (5/29/2014)
Sean Lange (5/29/2014)
Luis Cazares (5/29/2014)
JOIN keywords on the right of the tables.
+1000 That one drives me nuts!!! (ok I know it is a short trip)
NOT a fan...
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
May 29, 2014 at 2:58 pm
Sean Lange (5/29/2014)
Luis Cazares (5/29/2014)
JOIN keywords on the right of the tables.
+1000 That one drives me nuts!!! (ok I know it is a short trip)
NOT a fan of that format...
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
May 29, 2014 at 2:38 pm
I have had to use string splitters to help with removing certain characters from things like phone numbers.
Another common use is to split delimited strings.
Depending on the string there are...
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
May 29, 2014 at 1:45 pm
The sample query you provided does nothing of what you describe. How about posting a query that you have been working on to accomplish the business requirements and then...
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
May 29, 2014 at 1:35 pm
Sean Lange (5/29/2014)
samalex (5/29/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
May 29, 2014 at 1:23 pm
GilaMonster (5/29/2014)
SQLRNNR (5/29/2014)
Here's one more - Devs with SA accessFixed that for you.
That in and of itself is a pet peeve. But it is far worse when a DBA...
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
May 29, 2014 at 1:15 pm
GilaMonster (5/29/2014)
Gangadhara MS (5/29/2014)
Microsoft recommends For the TEMPDB database, create 1 data file per CPU.That recommendation belongs in the garbage.
And burned!!
:hehe:
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
May 29, 2014 at 12:55 pm
In addition to what has been said (e.g. nolock, nesting views and procs, poor formatting etc)
I don't like it when stored procedures are called "sprocs"
I don't like calling a server...
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
May 29, 2014 at 12:49 pm
Why are you pulling in discharge date if the parameter value is "A"?
Don't you want to pull in where the active field is equal to "A"?
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
May 29, 2014 at 12:25 pm
If you have those values assigned to a parameter in a report, you can take that parameter and pass it to a function in the filter of the dataset for...
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
May 29, 2014 at 12:12 pm
It depends. What are your business requirements for the code?
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
May 29, 2014 at 11:55 am
Viewing 15 posts - 2,971 through 2,985 (of 19,560 total)