Viewing 15 posts - 6,271 through 6,285 (of 19,560 total)
Did you map the database user to the SQL Login for Test1?
e.g.
CREATE USER Test1 FOR LOGIN Test1
WITH DEFAULT_SCHEMA = Marketing;
GO
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 17, 2012 at 5:27 am
perforating
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 17, 2012 at 5:16 am
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
May 16, 2012 at 9:30 pm
One huge difference is the basis on reputation. ASK SSC is a stack overflow model that depends on up-votes and OPs marking the question as answered.
I find the forums...
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 16, 2012 at 9:27 pm
This might be related to your problem:
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 16, 2012 at 5:49 pm
Typically, I see more activity in tempdb data files than in the log file. So if I have to choose, I put the tempdb data files on their own...
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 16, 2012 at 5:47 pm
You might want to look up TOP and ORDER BY.
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 16, 2012 at 4:57 pm
L' Eomot Inversé (5/16/2012)
Lynn Pettis (5/16/2012)
AntagonistAgonist
protagonist
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 16, 2012 at 4:50 pm
I think the method is sound.
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 16, 2012 at 4:37 pm
jcrawf02 (5/16/2012)
Brandie Tarvin (5/16/2012)
L' Eomot Inversé (5/15/2012)
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 16, 2012 at 6:40 am
Try this article:
http://jasonbrimhall.info/2010/07/07/sql-2008-dts/
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 16, 2012 at 5:58 am
RBarryYoung (5/15/2012)
SQLRNNR (5/15/2012)
Brandie Tarvin (5/14/2012)
Daniel Bowlin (5/14/2012)
RegionalSectional
Couch
Slouch
Crouch
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 16, 2012 at 5:55 am
L' Eomot Inversé (5/16/2012)
SQLRNNR (5/15/2012)
Brandie Tarvin (5/14/2012)
Daniel Bowlin (5/14/2012)
RegionalSectional
Couch
Couch-potato
Yam
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 16, 2012 at 5:54 am
Client
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 16, 2012 at 5:54 am
Are you running RC0, RTM or a CTP of 2012?
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 16, 2012 at 5:53 am
Viewing 15 posts - 6,271 through 6,285 (of 19,560 total)