Viewing 15 posts - 12,421 through 12,435 (of 19,560 total)
shield_21 (9/14/2010)
GilaMonster (9/12/2010)
XML? Why oh why?What's wrong with a properly normalised database design?
I think using XML datatype model would be more efficient.. I need to test them both though..
The query...
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 14, 2010 at 8:42 am
GilaMonster (9/14/2010)
Anyone feel like arguing database design?http://www.sqlservercentral.com/Forums/Topic981529-392-1.aspx
From that thread:
shield_21 (9/14/2010)
GilaMonster (9/12/2010)
What's wrong with a properly normalised database design?I think using XML datatype model would be more efficient..
Sounds like 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
September 14, 2010 at 8:37 am
sharonmtowler (9/14/2010)
Msg 319, Level 15, State 1, Line 18
Incorrect syntax near the keyword '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
September 14, 2010 at 8:37 am
Good to know you got 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
September 14, 2010 at 8:33 am
You're welcome.
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 14, 2010 at 8:30 am
shaik.masrath (9/14/2010)
It is not possible to take Transactional log backup. becoz in simple recovery model transactions are not stored in .LDF file after a full backup.
See Gail's response - 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
September 14, 2010 at 8:29 am
GilaMonster (9/14/2010)
Grant Fritchey (9/14/2010)
The Dixie Flatline (9/14/2010)
There are two types of people in the world. Those who can see what's coming next.And...
And you're obviously one of those...
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 14, 2010 at 8:28 am
Try something like this:
with preptab as (
select name,company,Email,row_number() over (partition by company,name order by email) as RowCnt
from tab
)
Select Name, Company, Email,RowCnt
From preptab
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 14, 2010 at 12:19 am
What are you trying to accomplish and what are the steps you are doing to accomplish that?
When do you get this error message (at which step)?
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 14, 2010 at 12:14 am
Or this?
select * from Table1
WHERE column1 NOT IN ( SELECT column1 FROM Table2)
And column1 NOT IN ( SELECT column1 FROM Table3)
And column1 NOT IN ( SELECT column1 FROM Table4)
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 14, 2010 at 12:11 am
What is the uniqueness of your data in that second CI? Have you examined using a numeric type for your CI?
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 14, 2010 at 12:09 am
Can you provide the DDL for the table?
Or even at least the data type(s) of the column(s) in the Clustered Index?
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 10:45 pm
A lot depends on the level of PCI compliance you are seeking to maintain and your auditor.
We had a stickler for an auditor and we maintained PCI compliance (highest level)...
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 10:41 pm
Sometimes that method works. However, make sure you perform a full backup before doing that. Also, i would do another full backup immediately after changing it back to...
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 10:35 pm
Thanks for clarifying that Steve. I meant to say that.
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 9:47 pm
Viewing 15 posts - 12,421 through 12,435 (of 19,560 total)