Viewing 15 posts - 17,926 through 17,940 (of 19,560 total)
rambilla4 (1/22/2010)
So there is NO option like with NO_LOG in SQL Server while Rebuilding Indexes like we have in ORACLE?
No
Here is a link with a doc to download 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
January 22, 2010 at 5:55 pm
SQLPirate (1/22/2010)
Yes I agree but I recommend to eliminate the sys schema!
Oops, yeah that's also a remnant from our environmental needs. The information in our current version also contains servernames,...
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
January 22, 2010 at 5:45 pm
rambilla4 (1/22/2010)
thanks,log backups are happening from the Native Log shipping backup job
I would do that as a part of a manual process - or change them to always run every...
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
January 22, 2010 at 5:15 pm
i took the liberty to update the script a little bit to allow better sorting based on different columns, such as Data.
By changing the Data column to a BigInt and...
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
January 22, 2010 at 5:14 pm
SQLPirate (1/22/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
January 22, 2010 at 5:03 pm
Dugi (1/22/2010)
I vote for CTE to find the duplicates in a table!:w00t::cool::hehe:
I second that vote.
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
January 22, 2010 at 4:59 pm
rambilla4 (1/22/2010)
I agreed with Mohammed Sort in tempdb option will use space of tempdb
If I select the option Sort results in tempdb, the log size of 12GB of MyDB...
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
January 22, 2010 at 4:57 pm
lmu92 (1/22/2010)
CirquedeSQLeil (1/22/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
January 22, 2010 at 4:30 pm
For me there are a couple of points of interest. What is a fair and equitable split? Do you want the Client as a repeat client? If...
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
January 22, 2010 at 3:48 pm
Here is an alternative script for Table Size in a database
-- Create the temp table for further querying
CREATE TABLE #temp(
rec_idint IDENTITY (1, 1),
table_namevarchar(128),
nbr_of_rowsint,
data_spacedecimal(15,2),
index_spacedecimal(15,2),
total_sizedecimal(15,2),
percent_of_dbdecimal(15,12),
db_sizedecimal(15,2))
-- Get all tables, names, and sizes
EXEC sp_msforeachtable...
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
January 22, 2010 at 3:40 pm
LOL
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
January 22, 2010 at 1:52 pm
Lynn Pettis (1/22/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
January 22, 2010 at 1:45 pm
Lynn Pettis (1/22/2010)
CirquedeSQLeil (1/22/2010)
Lynn Pettis (1/22/2010)
...I served 4 yrs Air Force (enlisted) (and yes, my oldest did enlist in the Army, but she roots for Air Force) ...
My dad 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
January 22, 2010 at 1:29 pm
Roy Ernest (1/22/2010)
Lynn Pettis (1/22/2010)
I'm off to see the Wizard ... ... in to the desert ...
You should have advised the OP that SQl Server would...
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
January 22, 2010 at 1:26 pm
Lynn Pettis (1/22/2010)
...I served 4 yrs Air Force (enlisted) (and yes, my oldest did enlist in the Army, but she roots for Air Force) ...
My dad was Army. I...
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
January 22, 2010 at 1:24 pm
Viewing 15 posts - 17,926 through 17,940 (of 19,560 total)