Viewing 15 posts - 9,571 through 9,585 (of 19,560 total)
For the SP to properly apply, you will have to have downtime in an A/P cluster.
If you redesigned your HA solution, you could minimize downtime by utilizing mirroring.
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
June 29, 2011 at 4:20 pm
Here are a few options:
PASS Summit (held annually) (http://www.sqlpass.org/summit/2011/)
SQLSkills.com (http://www.sqlskills.com/ImmersionEvents.asp
SQL Saturday and check for events in your area (http://sqlsaturday.com/)
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
June 29, 2011 at 4:14 pm
I'd go with the backup/restore.
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
June 29, 2011 at 4:07 pm
Clayton Lohm (3/10/2011)
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
June 29, 2011 at 4:06 pm
Will you post the results of this query?
;
with dbsize as
(select db_id() as DatabaseID,df.name, df.size
from sys.database_files df
)
Select df.DatabaseID,df.name,sum(convert(float,df.size))*8/1024 as FileSizeMB
From dbsize df
group by df.DatabaseID,df.name with rollup
;
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
June 29, 2011 at 4:04 pm
piotrka (6/29/2011)
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
June 29, 2011 at 3:51 pm
What you just said does not match what your first post said.
Please provide table structures and sample data in order to get an accurate query.
In the meantime, you should look...
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
June 29, 2011 at 1:46 pm
Jayanth_Kurup (6/29/2011)
Shouldn't this work for you , It seems pretty straight forwardupdate TGT
set TGT.address=SRC.address
from ADDRESSES TGT
join AddressUpdates SRC
on TGT.id=SRC.id
where SRC.address like 'PO%'
No. Only if the address is 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
June 29, 2011 at 1:27 pm
Here's another
select *
from ADDRESSES TGT
join AddressUpdates SRC
on TGT.id=SRC.id
where (SRC.address like 'PO%'
AND TGT.addresstype= 'Mailing'
)
...
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
June 29, 2011 at 1:23 pm
I had a bugger of a time getting it to work on one occasion and came up with that blog post I mentioned. It details all of the steps...
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
June 29, 2011 at 1:11 pm
Your query is restricting the result set to just records that are PO box and mailing address types.
Try this:
select *
from ADDRESSES TGT
join AddressUpdates SRC
on TGT.id=SRC.id
where SRC.address like 'PO%'
AND TGT.addresstype=
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
June 29, 2011 at 1:09 pm
Read through this and see if it helps
http://jasonbrimhall.info/2010/07/07/sql-2008-dts/
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
June 29, 2011 at 1:03 pm
Also, try to enable full-text index.
sp_fulltext_database enable
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
June 29, 2011 at 12:40 pm
Have you by chance tried the modify filegroup suggestion from Brandie?
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
June 29, 2011 at 12:38 pm
adocity (6/29/2011)
Steve-3_5_7_9 (6/29/2011)
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
June 29, 2011 at 11:57 am
Viewing 15 posts - 9,571 through 9,585 (of 19,560 total)