Viewing 15 posts - 10,021 through 10,035 (of 19,560 total)
jcrawf02 (5/23/2011)
SQLRNNR (5/23/2011)
Jim Murphy (5/23/2011)
Jack Corbett (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/2011)
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
May 23, 2011 at 10:14 pm
I haven't looked at the plans yet but something is different about them. The two show a different size. I am in the middle of reinsalling SQL Sentry...
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
May 23, 2011 at 5:50 pm
You may want to change it up.
Try the restore this way
RESTORE DATABASE WFCDBMesaba FILEGROUP='PRIMARY'
FROM DISK = 'E:\Mesaba\MESABA KRONOS BACKUP.BAK'
WITH PARTIAL, NORECOVERY, MOVE N'tkcsdb_Data' TO N'E:\Microsoft SQL Server\Data\WFCDBMesaba_data.mdf'
;
RESTORE DATABASE WFCDBMesaba...
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
May 23, 2011 at 5:34 pm
LutzM (5/23/2011)
Regarding the specific situation: it might be better for the person in...
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
May 23, 2011 at 5:01 pm
Jim Murphy (5/23/2011)
Jack Corbett (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/2011)
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
May 23, 2011 at 4:28 pm
sqlfriends (5/23/2011)
How about browsing website articles like msdn library of Sql servers, and this webiste of SQL server central.Thanks
Xoom then Ipad
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
May 23, 2011 at 4:27 pm
I would go kindle if just reading books. Xoom would be my second choice.
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
May 23, 2011 at 4:17 pm
jcrawf02 (5/23/2011)
Not a fan of roses, Craig?
Maybe he is saying he doesn't smell like roses??
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
May 23, 2011 at 3:53 pm
GilaMonster (5/23/2011)
Stefan Krzywicki (5/23/2011)
GilaMonster (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/2011)
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
May 23, 2011 at 3:37 pm
goushik (5/23/2011)
I got it...Thanks
Glad you got it. Can you share?
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
May 23, 2011 at 2:11 pm
For high-level stuff, sure it looks fine
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
May 23, 2011 at 1:47 pm
Please post some sample data and an example of the desired results.
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
May 23, 2011 at 1:27 pm
Looks like you have it already. Are you getting an error?
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
May 23, 2011 at 1:24 pm
Brandie Tarvin (5/23/2011)
GilaMonster (5/23/2011)
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
May 23, 2011 at 12:42 pm
Jim Murphy (5/20/2011)
SQLRNNR (5/20/2011)
For any interested, my recent exam experience is posted.
Nice job Jason! I'm a little late posting since I've been traveling since SQLRally ended.
I too have...
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
May 23, 2011 at 10:29 am
Viewing 15 posts - 10,021 through 10,035 (of 19,560 total)