Viewing 15 posts - 15,571 through 15,585 (of 19,560 total)
scziege (4/1/2010)
Hi,can you send a suggestions for a design of one table with 250 millions rows ?
Greetings
Design depends on needs, requirements, queries, etc.
Can you provide any of 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
April 1, 2010 at 1:22 pm
<MissingIndex Database="[Cloakware]" Schema="[dbo]" Table="[Metric]">
...
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
April 1, 2010 at 1:20 pm
We employ two methods. Both methods permit up to 24hour old data (business is ok with it). Method 1 is a full backup and restore nightly to 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
April 1, 2010 at 1:15 pm
Anarky
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
April 1, 2010 at 1:06 pm
Mr. Freeze
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
April 1, 2010 at 12:38 pm
WayneS (4/1/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
April 1, 2010 at 12:17 pm
Jack Corbett (4/1/2010)
GilaMonster (4/1/2010)
Now I have someone whining about my april fool's blog post. 🙁
That's totally annoying. Even Google has gotten into the act. Google is now Topeka....
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
April 1, 2010 at 12:14 pm
Please provide error messages and screen shots of your tcp ip settings.
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
April 1, 2010 at 12:13 pm
Hawkeye_DBA (4/1/2010)
Did you enable named pipes?I noticed that if you use the Browser it connects with Named Pipes, even if you have an alias.
SQL Browser does require named pipes.
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
April 1, 2010 at 12:12 pm
Paul White NZ (4/1/2010)
Alice
I knew somebody would jump from Batman to Alice in wonderland. (Madhatter is a batman villain too though not well known).
Tweedle Dee
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
April 1, 2010 at 12:10 pm
Trey Staker (4/1/2010)
I fell for one...
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
April 1, 2010 at 12:09 pm
GilaMonster (4/1/2010)
Now I have someone whining about my april fool's blog post. 🙁
I enjoyed the blog post. I felt silly that I hadn't thought of a great idea like...
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
April 1, 2010 at 12:02 pm
george sibbald (4/1/2010)
got caught by the 'quoting whilst new post pops up' trick
that is mildly frustrating
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
April 1, 2010 at 11:56 am
The Dixie Flatline (4/1/2010)
I thought "hamster" was a collation.
No, the collation is "hamster poo"
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
April 1, 2010 at 11:55 am
Alvin Ramard (4/1/2010)
[font="Verdana"]The undocumented command DBCC TimeWarp 'VerifyOnly'
(Select all that apply)
A - Returns the same results with SQL 2008...
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
April 1, 2010 at 11:54 am
Viewing 15 posts - 15,571 through 15,585 (of 19,560 total)