SQLRNNR

Forum Replies Created

Viewing 15 posts - 4,666 through 4,680 (of 19,560 total)

RE: Are the posted questions getting worse?

WayneS (4/25/2013)
SQLRNNR (4/25/2013)
Brandie Tarvin (4/25/2013)
Guys,
The flowchart thing worked wonderfully. The kids had a blast.
The first thing I said was "How many of you play video games?" The answer, 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

April 25, 2013 at 11:28 am

#1610073
RE: Are the posted questions getting worse?

Brandie Tarvin (4/25/2013)
SQLRNNR (4/25/2013)
Brandie Tarvin (4/25/2013)
Guys,
The flowchart thing worked wonderfully. The kids had a blast.
The first thing I said was "How many of you play video games?" The answer,...
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

April 25, 2013 at 11:13 am

#1610062
RE: Today's Random Word!

Revenant (4/25/2013)
SQLRNNR (4/25/2013)
JAZZ Master (4/25/2013)
crookj (4/25/2013)
SQLRNNR (4/24/2013)
Cliff Jones (4/24/2013)
SQLRNNR (4/24/2013)
JAZZ Master (4/24/2013)
crookj (4/24/2013)
Daniel Bowlin (4/24/2013)
Revenant (4/23/2013)
opc.three (4/23/2013)
Impasse
It's called "deadlock," among us SQLS pros. 😉
Mexican standoff
Logjam
beaver dam
Oregon
Trail
Bison
Thunderbeast
Thunder Up!
Thunderstruck
Thunderbird
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

April 25, 2013 at 10:05 am

#1610023
RE: Are the posted questions getting worse?

Brandie Tarvin (4/25/2013)
Guys,
The flowchart thing worked wonderfully. The kids had a blast.
The first thing I said was "How many of you play video games?" The answer, of course, was...
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

April 25, 2013 at 10:01 am

#1610020
RE: Triggers 2

Thanks Hugo.
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

April 25, 2013 at 9:49 am

#1610010
RE: Today's Random Word!

JAZZ Master (4/25/2013)
crookj (4/25/2013)
SQLRNNR (4/24/2013)
Cliff Jones (4/24/2013)
SQLRNNR (4/24/2013)
JAZZ Master (4/24/2013)
crookj (4/24/2013)
Daniel Bowlin (4/24/2013)
Revenant (4/23/2013)
opc.three (4/23/2013)
Impasse
It's called "deadlock," among us SQLS pros. 😉
Mexican standoff
Logjam
beaver dam
Oregon
Trail
Bison
Thunderbeast
Thunder Up!
Thunderstruck
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

April 25, 2013 at 9:02 am

#1609989
RE: Are the posted questions getting worse?

GilaMonster (4/25/2013)
Does whoever has my crystal ball want to give this a try? http://www.sqlservercentral.com/Forums/Topic1446457-392-1.aspx
Sweet - Gail is a pedant when she has no crystal ball.
Looking at the question, there was...
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

April 25, 2013 at 8:40 am

#1609978
RE: Today's Random Word!

Cliff Jones (4/24/2013)
SQLRNNR (4/24/2013)
JAZZ Master (4/24/2013)
crookj (4/24/2013)
Daniel Bowlin (4/24/2013)
Revenant (4/23/2013)
opc.three (4/23/2013)
Impasse
It's called "deadlock," among us SQLS pros. 😉
Mexican standoff
Logjam
beaver dam
Oregon
Trail
Bison
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

April 24, 2013 at 1:29 pm

#1609706
RE: Cannot create an account in my SQL

Is the SQL Service account a domain account? If so, which domain?
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

April 24, 2013 at 1:19 pm

#1609702
RE: Cannot create an account in my SQL

It looks like the trust relationship is not fully propagated or does not exist both ways.
Try setting an explicit trust where Domain A trusts Domain B.
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

April 24, 2013 at 12:21 pm

#1609676
RE: 2005 Ent to 2008 R2 Std

Here is the doc showing the upgrade paths
http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx
I'd also recommend upgrading to 2012 if possible. Mainstream support for R2 ends next year (7/8/2014)
http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=SQL
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

April 24, 2013 at 12:18 pm

#1609674
RE: Importance of Style on Exam?

dan-572483 (4/24/2013)
But you wouldn't miss an exam question because you picked the answer that left out the AS would you?
No, but AS is preferred for readability.
The exam does not test...
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

April 24, 2013 at 12:13 pm

#1609670
RE: Importance of Style on Exam?

You need to know what the query does and not necessarily the style
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

April 24, 2013 at 12:10 pm

#1609665
RE: Today's Random Word!

JAZZ Master (4/24/2013)
crookj (4/24/2013)
Daniel Bowlin (4/24/2013)
Revenant (4/23/2013)
opc.three (4/23/2013)
Impasse
It's called "deadlock," among us SQLS pros. 😉
Mexican standoff
Logjam
beaver dam
Oregon
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

April 24, 2013 at 12:08 pm

#1609664
RE: FK to IDENTITY

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

April 24, 2013 at 12:07 pm

#1609663

Viewing 15 posts - 4,666 through 4,680 (of 19,560 total)