Viewing 15 posts - 17,521 through 17,535 (of 19,560 total)
I typically use 13 and 111 in order to perform transcontinental 1TB database transfers to SQL Server VMs.
I am still working on integrating flag 138 to properly initialize the database...
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
February 6, 2010 at 4:42 am
This is rather simplistic.
Select pav.ProductAttributeValueID,pc.CategoryName, pca.ProductCategoryAttributeName,pav.AttributeValue
From ProductAttributeValue pav
Inner Join ProductCategoryAttribute pca
On pca.productcategoryattributeid = pav.productcategoryattributeid
Inner Join ProductCategory pc
On pc.ProductCategoryID = pca.ProductCategoryID
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
February 6, 2010 at 4:33 am
The answer to that question is: It Depends.
You will more than likely need numerous queries to support the various different aspects of your application. Some queries should require...
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
February 6, 2010 at 4:21 am
Knowing what the errors were would be good. Defining the table is a definite good method to perform this. It certainly simplifies the query and could make 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
February 6, 2010 at 4:18 am
WayneS (2/5/2010)
The Dixie Flatline (2/5/2010)
Wayne, and anyone else, I've taken the liberty of creating a forum specifically for DBCC TIMEWARP here.
"SSC ... it's not...
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
February 5, 2010 at 11:01 pm
It's new in 2008 R2D2.
Until you upgrade to that version, you must provide the minimum of 137 parameters. It is also highly recommended to use some of the 255...
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
February 5, 2010 at 10:59 pm
innoculate
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
February 5, 2010 at 5:01 pm
ennunciate
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
February 5, 2010 at 3:30 pm
Chad Crawford (2/5/2010)
Maybe we could turn this into an April Fool question of the day.
Which of these methods can be used to restore a damaged database to the state...
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
February 5, 2010 at 3:29 pm
Jack Corbett (2/5/2010)
Alvin Ramard (2/5/2010)
The Dixie Flatline (2/5/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
February 5, 2010 at 3:28 pm
That is a nice find.
Thanks Max
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
February 5, 2010 at 3:25 pm
mediate
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
February 5, 2010 at 3:20 pm
cellmate
we have seen watergate 3 times prior to this entry in the meme
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
February 5, 2010 at 3:15 pm
annihilate
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
February 5, 2010 at 3:05 pm
Lynn Pettis (2/5/2010)
Why is it that when you ask someone to SHOW you want they are trying to do...
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
February 5, 2010 at 3:03 pm
Viewing 15 posts - 17,521 through 17,535 (of 19,560 total)