Viewing 15 posts - 2,116 through 2,130 (of 19,560 total)
Koen Verbeeck (9/9/2014)
Well, I hope Steve corrects the issue and awards points back.I thought I lost my sanity there for a moment 🙂
What little you had left?? :hehe::hehe::hehe::hehe::hehe::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
September 9, 2014 at 7:38 am
For me, a real scary dba is one who insists on not learning anything new, and continuing to do the same thing day in and day 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
September 8, 2014 at 3:08 pm
Eirikur Eiriksson (9/8/2014)
itsanjayg (9/8/2014)
thanks for question.
I tried in SQL2012 and it works fine without any error.
like this....
CREATE SYNONYM Emp FOR Appconfig
SELECT * FROM emp
it will successfully show...
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
September 8, 2014 at 1:35 pm
Good stuff from the big 3 already. Here is an article to chew on that elaborates a bit more on the TVF perf problems
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
September 4, 2014 at 5:49 pm
Grant Fritchey (9/4/2014)
polkadot (9/4/2014)
By extensible I mean, current practices that will allow maximum future flexibility to rearranging server and network infrastructure. For example, in the near future we...
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
September 4, 2014 at 1:49 pm
WayneS (9/4/2014)
SQLRNNR (9/4/2014)
Roy Ernest (9/4/2014)
Do we have any new...
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
September 4, 2014 at 10:45 am
The lower privilege user will need permissions to alter the database (mirror and principal). Or they will need to be a member of sysadmin.
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
September 4, 2014 at 10:03 am
george sibbald (9/4/2014)
check out SQLIO and SQLIOSIM
+1
Another one is HammerDB
http://hammerora.sourceforge.net/
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
September 4, 2014 at 9:49 am
DrKiller (9/4/2014)
CTEs doesn't ALWAYS need a semi-colon in front.
This for example works fine:
DECLARE @tmpVariable INT
WITH cte
AS
(
SELECT 1/0 as 'Result'
)
SELECT *
FROM...
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
September 4, 2014 at 8:50 am
Roy Ernest (9/4/2014)
Do we have any new ANSI Joe...
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
September 4, 2014 at 8:32 am
silver
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
September 4, 2014 at 7:06 am
Since you already ran reconfigure, you shouldn't need to worry about that message. Think of it as a reminder that is displayed every time you change a config.
Just be...
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
September 3, 2014 at 2:24 pm
Eirikur Eiriksson (9/3/2014)
Alvin Ramard (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/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
September 3, 2014 at 2:21 pm
Sean Lange (9/3/2014)
Koen Verbeeck (9/3/2014)
Bah. I couldn't resist it.Did he go "we we we all the way home???" :-D:-D:-D
Or was it wee wee wee all the way home?
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
September 3, 2014 at 1:28 pm
Koen Verbeeck (9/3/2014)
Bah. I couldn't resist it.
You antagonist;-)
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
September 3, 2014 at 1:28 pm
Viewing 15 posts - 2,116 through 2,130 (of 19,560 total)