Viewing 15 posts - 16,861 through 16,875 (of 19,560 total)
Do you have a trigger on the table?
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
March 4, 2010 at 3:07 pm
Any database can be set to readonly mode. Readonly means that you can only read from the database.
Standby is typically used in a log-shipping or mirroring setup. 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
March 4, 2010 at 11:55 am
Wayne and Amit are correct. Wayne has some additional options for high-availability. There are even more options that can help with high-availability. You should give us what...
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
March 4, 2010 at 11:50 am
ramadesai108 (3/4/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
March 4, 2010 at 11:37 am
Are you seeing 0's in your table currently, or are you referring to @@identity returning a 0 during this proc?
According to script and table definition, you should not be inserting...
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
March 4, 2010 at 10:59 am
catamount - what you do with the cat after it becomes 2-d
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
March 4, 2010 at 10:43 am
Jeff Moden (3/4/2010)
It's not a common occurance, for sure, but in one company I worked in, there were some remarkable business folks who were actually very good at defining what...
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
March 4, 2010 at 10:41 am
Thanks. I learned something today.
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
March 4, 2010 at 10:24 am
cataclysmic
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
March 4, 2010 at 10:14 am
catatonic
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
March 4, 2010 at 9:06 am
Check out the following
http://blogs.msdn.com/chkoenig/archive/2008/12/01/upgrading-from-sql-2000-2005-to-2008.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
March 4, 2010 at 9:04 am
They're not the same thing, but they are similar.
In basic terms, a log backup is the backup of changes (transactions) since the last backup. An incremental backup does 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
March 3, 2010 at 11:46 pm
NewBeeSQL (3/3/2010)
Does it require to have an index on FK columns. can any one please post possitives and negatives of having an...
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
March 3, 2010 at 11:44 pm
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
March 3, 2010 at 10:04 pm
Jack Corbett (3/3/2010)
john.arnott (3/3/2010)
RBarryYoung (3/2/2010)
Paul White (3/2/2010)
CirquedeSQLeil (3/2/2010)
NFL Football team
And I would (genuinely) guess at Chicago. But why ask about the Bears?
It's a meme isn't it. I was...
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
March 3, 2010 at 7:46 pm
Viewing 15 posts - 16,861 through 16,875 (of 19,560 total)