Viewing 15 posts - 12,451 through 12,465 (of 19,560 total)
SKYBVI (9/13/2010)
you delete all the tables,objects linked with the schema.
Using the GUI in "Object Explorer" (MS SQL Management Studio) Expand the...
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
September 13, 2010 at 2:37 pm
That's good.
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
September 13, 2010 at 2:36 pm
Have a read at this article:
http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
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
September 13, 2010 at 1:01 pm
This should be of some help
With period1 as (
select
@date1 as period_1,
max(RISK) as risk,
CUSTOMER# as cust,
Max(OFFICER) as officer,
Max(REGION) as region,
Max(DATE) as dte,
sum(AMOUNT) AS sum_amnt_1
FROM...
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
September 13, 2010 at 12:58 pm
Datatype and implicit conversion.
It looks like your ID column is not an Integer and is a string of some type.
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
September 13, 2010 at 12:39 pm
Yes - all files.
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
September 13, 2010 at 12:10 pm
Are you sure the schema was dropped?
Are there any tables or objects in the database using that schema?
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
September 13, 2010 at 12:00 pm
Please provide sample data and DDL. This will help people better find the issue.
As it stands - it looks like you have some bad data.
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
September 13, 2010 at 11:58 am
A couple of things looking at this would lead me to access patterns for the underlying objects.
I would do the inner joins first and the the outer joins.
You also have...
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
September 13, 2010 at 11:48 am
At least you have a workaround. It would be nice to be able to reproduce this situation you are having so more people could look at it and maybe...
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
September 13, 2010 at 11:28 am
To add to that - not everybody needs to have point in time recovery. Due to this, it would have been bad design to force everybody to perform log...
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
September 13, 2010 at 11:24 am
Alvin Ramard (9/13/2010)
amenjonathan (9/13/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
September 13, 2010 at 11:21 am
amenjonathan (9/13/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
September 13, 2010 at 11:18 am
Trevor R Udden (9/13/2010)
Did I miss a major citiation at the end of your article? You might want to try not blantly plagirizing others work. The...
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
September 13, 2010 at 11:16 am
r5d4 (9/13/2010)
The article has served to remind me to re-read the original.I do hope Omeswar is not going to get paid for his Copy and Paste technique.
I strongly suspect he...
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
September 13, 2010 at 11:15 am
Viewing 15 posts - 12,451 through 12,465 (of 19,560 total)