Viewing 15 posts - 3,706 through 3,720 (of 19,560 total)
A string splitter such as the delimitedsplit8k that can be found here on SSC would be a good start if the data is concatenated into a single string. This...
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
February 13, 2014 at 11:02 pm
Thanks for the fun one today Steve.
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
February 13, 2014 at 10:56 pm
I use VMs for a few different things.
I use VMs for my lab. I also use them to keep VPN clients separate.
Here's a series of articles I did on...
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
February 13, 2014 at 10:54 pm
Ed Wagner (2/13/2014)
TomThomson (2/13/2014)
SQLRNNR (2/13/2014)
Revenant (2/13/2014)
The Dixie Flatline (2/13/2014)
JAZZ Master (2/13/2014)
crookj (2/13/2014)
WotD - ubiquityomnipresence
omnipotence
omniscience
?. ??, ????? ?? ??
???? ? ??? ?
Language
Barrier
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
February 13, 2014 at 10:42 pm
Revenant (2/13/2014)
The Dixie Flatline (2/13/2014)
JAZZ Master (2/13/2014)
crookj (2/13/2014)
WotD - ubiquityomnipresence
omnipotence
omniscience
?. ??, ????? ?? ??
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
February 13, 2014 at 1:55 pm
Jack Corbett (2/13/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
February 13, 2014 at 12:46 pm
You can do that via a logon trigger at the server level.
Here is an article on that
http://jasonbrimhall.info/2010/04/06/ip-and-default-trace-t-sql-tuesday-005/
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
February 13, 2014 at 11:01 am
with just a couple of characters replace works quite nicely.
Another option that people use from time to time is a function that loops through the string to replace characters. ...
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
February 13, 2014 at 10:16 am
Try this article.
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
February 13, 2014 at 9:40 am
Eugene Elutin (2/13/2014)
venoym (2/13/2014)
I'm going to be the lone guy here and go out on a limb...
Don't you worry, you are not alone!
Threre are plenty of cowboy developers around....
😉
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
February 13, 2014 at 8:56 am
vigneshkumart50 (2/12/2014)
It worked. Thanks a lot.
You're welcome
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
February 13, 2014 at 8:29 am
Junglee_George (2/13/2014)
Thanks SQLRNNR, Very informative.Please explain the difference of usage of REPLACE in your first post.
Also, why you used '$-','-$' in the query.
You are welcome.
David answered 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
February 13, 2014 at 8:28 am
David Burrows (2/13/2014)
Junglee_George (2/13/2014)
Thanks SQLRNNR, Very informative.Please explain the difference of usage of REPLACE in your first post.
Also, why you used '$-','-$' in the query.
It is to move the minus...
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
February 13, 2014 at 8:26 am
The use of sp_MSforeachdb can have unintended results. It will occasionally miss databases. There are better methods (such as a cursor - and considering msforeachdb is just 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
February 13, 2014 at 8:24 am
If you were to be using SQL 2012 or 2014, then this would work
DECLARE @dollar TABLE (id INT IDENTITY(1,1),Cost INT)
INSERT INTO @dollar
(...
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
February 12, 2014 at 10:43 pm
Viewing 15 posts - 3,706 through 3,720 (of 19,560 total)