Viewing 15 posts - 17,506 through 17,520 (of 19,560 total)
No problem with encrypting communications to the server.
Another method is to establish an ssl certificate on both the client and the server.
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 6, 2010 at 2:26 pm
HAHA
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 6, 2010 at 2:23 pm
The Dixie Flatline (2/6/2010)
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 6, 2010 at 2:18 pm
I see what you are saying now.
A recursive CTE using the query I provided you inside the cte should get that for you. Just use the parentcategory...
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 6, 2010 at 12:33 pm
fotechvnu (2/6/2010)
Thank CirquedeSQLeilyour post is not true with my case
when ProductCategoryID=4
it must get all child of ProductCategoryID =4
but when i input ProductCategoryID = 4
it get only Mobile phone
I don't follow...
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 6, 2010 at 12:26 pm
I neglected a critical piece of my post - it is the sequence in which the parameters are passed to timewarp.
One must still use all of the parameters - it...
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 6, 2010 at 12:24 pm
I like what Grant added. Many of us are working in trimmed down shops with plenty of responsibility and duties for three dbas each. Being detail oriented, you...
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 6, 2010 at 12:22 pm
Dave Ballantyne (2/3/2010)
Unfortunately that does not seem to be the case...
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 6, 2010 at 12:14 pm
extraction
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 6, 2010 at 12:11 pm
Thanks - nice script.
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 6, 2010 at 12:06 pm
Alvin Ramard (2/6/2010)
CirquedeSQLeil (2/6/2010)
Alvin Ramard (2/6/2010)
Well, at least we don't have to worry that someone will mess up their database by running the command.
Don't be too sure about that (evil...
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 6, 2010 at 11:59 am
Mad-Dog (2/6/2010)
CirquedeSQLeil (2/5/2010)
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 6, 2010 at 11:56 am
Alvin Ramard (2/6/2010)
Well, at least we don't have to worry that someone will mess up their database by running the command.
Don't be too sure about that (evil chuckle)!!
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 6, 2010 at 11:31 am
The Dixie Flatline (2/6/2010)
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 6, 2010 at 11:29 am
Dave Ballantyne (2/6/2010)
Bugger.Sliced a nice inch long flap of skin off my thumb this morning.
Typing with one hand is a slow process 🙂
Into the plastic surgery clinic tommorrow
Ouch.
Hope you...
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 6, 2010 at 11:24 am
Viewing 15 posts - 17,506 through 17,520 (of 19,560 total)