Viewing 15 posts - 9,076 through 9,090 (of 19,560 total)
I'm not sure what you mean.
Post a sample of how you expect to see it displayed
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
August 12, 2011 at 4:18 pm
I think it is significantly more difficult. I recommend using the published information from Microsoft about what to study.
This is a bit of a study guide I put together...
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
August 12, 2011 at 3:43 pm
Yup, all of those are viable options as well.
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
August 12, 2011 at 3:38 pm
You have your join criteria backwards.
Try this.
With CatList (Child, Parent,IDNo, ParentIDNo, Clearance) as
(Select ChildCategory, Category, IDNo, ParentIDNo,Clearance
From Category
where parentidno is null
Union All
Select Cat.ChildCategory, Cat.Category, Cat.IDNo, Cat.ParentIDNo ,Cat.Clearance
From Category...
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
August 12, 2011 at 3:31 pm
Here are two options to do that:
--option 1
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'SQLDBA' ,
@recipients = 'myEmail@myDomain.com' ,
--@body = @messageBody ,
...
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
August 12, 2011 at 3:23 pm
Besides Elliotts slick tool, you can do this easily from msdb database to msdb database via sql script and a dts transfer.
Here would be the first part of that method.
SELECT...
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
August 12, 2011 at 11:24 am
Are they all stored in MSDB or the file system?
Also, I am curious why stay with SQL 2000?
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
August 12, 2011 at 11:16 am
Stefan Krzywicki (8/12/2011)
SQLRNNR (8/12/2011)
Stefan Krzywicki (8/12/2011)
SQLRNNR (8/12/2011)
Stefan Krzywicki (8/12/2011)
SQLRNNR (8/12/2011)
Lynn Pettis (8/11/2011)
WayneS (8/11/2011)
Lynn Pettis (8/11/2011)
...
Lynn, I'm very glad that you are moving back. I know you've been a bit unhappy...
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
August 12, 2011 at 10:56 am
Stefan Krzywicki (8/12/2011)
SQLRNNR (8/12/2011)
Stefan Krzywicki (8/12/2011)
SQLRNNR (8/12/2011)
Lynn Pettis (8/11/2011)
WayneS (8/11/2011)
Lynn Pettis (8/11/2011)
...
Lynn, I'm very glad that you are moving back. I know you've been a bit unhappy there (what with...
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
August 12, 2011 at 10:46 am
It would appear to me that prior to using 10000, you have been lucky that there are no duplicate values.
set @nom=(select nom from dbo.mylogin1 where numtel=@numtel)
set @prenom=(select prenom from dbo.mylogin1...
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
August 12, 2011 at 10:35 am
I have done this using a script component as well as a stored proc that utilizes xp_cmdshell. Both can easily be used in SSIS to populate your object prior...
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
August 12, 2011 at 10:29 am
When writing it out to text file, I believe you need to use UTF-16.
As for SSMS, I ran into that issue once upon a time and am trying to recall...
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
August 12, 2011 at 10:21 am
Ray K (8/12/2011)
crookj (8/12/2011)
Ray K (8/12/2011)
crookj (8/12/2011)
SQLRNNR (8/12/2011)
Revenant (8/12/2011)
SQLRNNR (8/12/2011)
StrengthedConan
Barbarian
Red Sonja
Red Dawn
Wolverines!!!!!!!
Buckeyes
Cheaters?
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
August 12, 2011 at 10:20 am
Stefan Krzywicki (8/12/2011)
SQLRNNR (8/12/2011)
Lynn Pettis (8/11/2011)
WayneS (8/11/2011)
Lynn Pettis (8/11/2011)
...
Lynn, I'm very glad that you are moving back. I know you've been a bit unhappy there (what with being so close...
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
August 12, 2011 at 10:17 am
Steve Jones - SSC Editor (8/12/2011)
- work in a complex development environment that does automated builds at high volumes (> 1x day)
-...
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
August 12, 2011 at 10:13 am
Viewing 15 posts - 9,076 through 9,090 (of 19,560 total)