Viewing 15 posts - 3,886 through 3,900 (of 19,560 total)
Luis Cazares (2/5/2014)
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, 2014 at 5:36 pm
That feature disappeared with SQL 2005. You can get something like it if you have all of your backups in the same backup file or in the same backup...
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, 2014 at 5:18 pm
suresh0534 (2/5/2014)
But there is no end date....I need to calculate the End date based on Start Date.
Example I am calculating the 2013 year Data.
If Start date date...
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, 2014 at 5:15 pm
dwain.c (2/5/2014)
Jeff Moden (2/5/2014)
ChrisM@Work (2/4/2014)
He's calling summer on one sighting of a swallow.
He should come to Michigan. It was snowing to beat the band a couple of days ago...
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, 2014 at 5:09 pm
I think there is a problem with your sample data.
There is at least one end date that occurs prior to the start date for the associated record.
Additionally, since the end...
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, 2014 at 5:02 pm
duplicate post, please post replies at this post instead http://www.sqlservercentral.com/Forums/Topic1538410-392-1.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
February 5, 2014 at 4:58 pm
homebrew01 (2/5/2014)
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, 2014 at 4:55 pm
Steve Jones - SSC Editor (1/28/2014)
GilaMonster (1/16/2014)
That risk is why the log backup interval should be less than the allowable data loss for the system.
Best quote I've seen in awhile...
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, 2014 at 4:54 pm
No.
And since you can see the stored procs through the linked server, that screams that there is a security flaw in your linked server setup. Somebody has probably created...
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, 2014 at 4:37 pm
Revenant (2/5/2014)
Sean Lange (2/5/2014)
SQLRNNR (2/5/2014)
Sean Lange (2/5/2014)
WayneS (2/5/2014)
Sean Lange (2/4/2014)
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, 2014 at 3:06 pm
Revenant (2/5/2014)
Ed Wagner (2/5/2014)
JAZZ Master (2/5/2014)
SQLRNNR (2/5/2014)
Ed Wagner (2/5/2014)
SQLRNNR (2/5/2014)
Kurt W. Zimmerman (2/5/2014)
BWFC (2/5/2014)
Kurt W. Zimmerman (2/5/2014)
Ed Wagner (2/5/2014)
BWFC (2/5/2014)
SQLRNNR (2/4/2014)
tokeDraw
Shoot
Skeet
Clay
Pot
hemp
Rope
twine
wire
Wired (the magazine)
methamphetamines (not a magazine ;-))
Lab
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, 2014 at 1:48 pm
Sean Lange (2/5/2014)
WayneS (2/5/2014)
Sean Lange (2/4/2014)
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, 2014 at 12:37 pm
IMHO - I wouldn't use the wizard.
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, 2014 at 12:17 pm
Ed Wagner (2/5/2014)
SQLRNNR (2/5/2014)
Kurt W. Zimmerman (2/5/2014)
BWFC (2/5/2014)
Kurt W. Zimmerman (2/5/2014)
Ed Wagner (2/5/2014)
BWFC (2/5/2014)
SQLRNNR (2/4/2014)
tokeDraw
Shoot
Skeet
Clay
Pot
hemp
Rope
twine
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, 2014 at 11:13 am
Evil Kraig F (2/5/2014)
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, 2014 at 11:06 am
Viewing 15 posts - 3,886 through 3,900 (of 19,560 total)