Viewing 15 posts - 19,171 through 19,185 (of 19,560 total)
rshm35 (11/9/2009)
The query has 12 joins in that 2 views are there...i can not use indexed view..help me out..
We need more information to help. Some great comments have been...
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
November 9, 2009 at 3:49 pm
I think a script component task would be your best bet. We use the scripts for similar functionality.
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
November 9, 2009 at 3:46 pm
nice analogy Alvin.
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
November 9, 2009 at 3:14 pm
It sounds feasible and doable.
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
November 9, 2009 at 3:09 pm
Do I understand this correctly?
1. In SSIS, but only using SQL tasks and .Net Script components?
2. Reliable FTP?
3. FTP needs to be secure?
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
November 9, 2009 at 2:50 pm
12 Tables in a join is a handful. However, I have seen it done many times over at several clients. A little query tuning can go a long...
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
November 9, 2009 at 12:39 pm
Keep in mind, that is only checking for the first column in a foreign key. You will need to add additional code if there is more than one column...
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
November 9, 2009 at 12:02 pm
This might get you close to what you want.
select o.name,c.name from sys.sysreferences r
inner join sys.syscolumns c
on r.fkeyid = c.id
and r.fkey1 = c.colid
Inner Join sys.sysobjects o
on c.id = o.id
Left Outer Join...
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
November 9, 2009 at 12:01 pm
When the query isn't running, what is your processor usage?
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
November 9, 2009 at 11:21 am
Doh, option 6 tripped me up - should have read it more closely.
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
November 9, 2009 at 11:02 am
Amazing how sideways the Thread goes when talking about Pork Chops and Kilts.
Now there's an image - Kilts with Pork Chops.
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
November 9, 2009 at 10:17 am
Grant Fritchey (11/9/2009)
Jeff Moden (11/8/2009)
Jack Corbett (11/7/2009)
Grant Fritchey (11/7/2009)
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
November 9, 2009 at 10:13 am
Just downloaded the SQL MVP Deep Dive book. Now for some light reading over the weekend.
Woot :w00t:
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
November 6, 2009 at 6:49 pm
Try loading the date from the header into a variable and then add a data transformation task for a derived colum. The value in the derived column that 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
November 6, 2009 at 1:46 pm
Another method is to setup a scheduled job to copy them to another location (commonly a central location for log files) that is firewalled, protected and on an encrypted file...
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
November 6, 2009 at 10:04 am
Viewing 15 posts - 19,171 through 19,185 (of 19,560 total)