SQLRNNR

Forum Replies Created

Viewing 15 posts - 5,476 through 5,490 (of 19,560 total)

RE: Today's Random Word!

cheddar
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

December 13, 2012 at 12:22 pm

#1568442
RE: IDENTITY INSERT

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

December 13, 2012 at 9:18 am

#1568361
RE: Renaming a procedure

Thanks Hugo for your insights.
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

December 12, 2012 at 1:23 am

#1567738
RE: Today's Random Word!

Revenant (12/11/2012)
bcsims 90437 (12/11/2012)
SQLRNNR (12/11/2012)
skillet
scramble
crypto
keeper
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

December 11, 2012 at 11:18 pm

#1567705
RE: Today's Random Word!

skillet
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

December 11, 2012 at 2:47 pm

#1567627
RE: Mirrors

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

December 11, 2012 at 2:26 pm

#1567620
RE: Today's Random Word!

Revenant (12/7/2012)
opc.three (12/7/2012)
Daniel Bowlin (12/7/2012)
foray
Fourier
transform
er.er.er.ers
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

December 10, 2012 at 11:54 am

#1567133
RE: What Counts for a DBA: Being Replaceable

Mike Dougherty-384281 (12/8/2012)
Another good reason to be replaceable is that you should be able to "hand off" to a coworker so you can advance within the organization. If you've...
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

December 10, 2012 at 11:40 am

#1567127
RE: STUFF - 2

Thanks Ron
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

December 10, 2012 at 11:21 am

#1567124
RE: Which Statement will execute sucessfully

Stuart Davies (12/7/2012)
Assumed I had rights to person and beneficiary schemas and got it right.
Otherwise the answer could be it depends,it depends,it depends
+1
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

December 7, 2012 at 11:08 am

#1566711
RE: Made stupid mistake, need help removing duplicates

Nope, can't run that code on SQL 2000. I figured it was SQL 2008 since it wasn't noted and this is the 2008 forum.
It will take a different method...
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

December 7, 2012 at 11:06 am

#1566710
RE: Made stupid mistake, need help removing duplicates

This should be easily deduped using that script in the link I provided - you will just need to customize it for your table.
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

December 7, 2012 at 10:23 am

#1566698
RE: what ports SQL uses

Best would be to either change it to a static port or open a range.
On occasion a Named instance can use port 1433. But it can also use 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

December 6, 2012 at 7:23 pm

#1566423
RE: what ports SQL uses

Then open up for the dynamic port you listed.
Also, open for TCP port 1433.
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

December 6, 2012 at 6:47 pm

#1566418
RE: Made stupid mistake, need help removing duplicates

I think you can still dedupe your data.
here's an article on deduping to get you started
http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/
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

December 6, 2012 at 6:42 pm

#1566414

Viewing 15 posts - 5,476 through 5,490 (of 19,560 total)