Viewing 15 posts - 7,081 through 7,095 (of 19,560 total)
Thanks for 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
January 17, 2012 at 11:55 pm
tilew-948340 (1/17/2012)
SQLRNNR (1/17/2012)
Shawn Melton (1/17/2012)
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 17, 2012 at 11:09 pm
Shawn Melton (1/17/2012)
... grabbing this information through the GUI window[/url] (properties window in SSMS). My example was using a specific login but it should work for a role as well.
It...
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 17, 2012 at 7:52 pm
Are you trying to create the role through the GUI?
If so, there is a script button that will script out that role. Make your modifications to the script 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 17, 2012 at 5:59 pm
trinamjose23 (1/17/2012)
hii,weather we can install sql server 2008 r2 on unix machine , any company's they do this .....
Windows OS is required.
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 17, 2012 at 5:56 pm
I had a similar requirement once upon a time.
Here is how I solved it. You will need to obviously adapt the structures to your needs, but the principles should...
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 17, 2012 at 5:13 pm
The other option in SQL 2000 was to add a line of code to each proc that would write out execution details to a log 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
January 17, 2012 at 4:56 pm
Please run the query on this page and report back the results.
http://jasonbrimhall.info/2011/12/05/database-data-and-log-size-info/
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 17, 2012 at 4:51 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
January 17, 2012 at 3:43 pm
jgenovese (1/17/2012)
DBCC SHRINKFILE ... , TRUNCATEONLYon the file in question itself, not the log
your'e confisuing it with:
BACKUP LOG ... WITH TRUNCATE_ONLY
When you do this, you are releasing space to 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
January 17, 2012 at 3:41 pm
logicinside22 (1/17/2012)
Thanks GeoffI tried on local machine and it works fine .thanks for nice explanation.
I can change to the any number?- 7 to 15 or 30?
Yes you can....
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 17, 2012 at 3:00 pm
Charles Kincaid (1/17/2012)
...In practice it might be better to have a scratch location for the master and then read the destinations from some table.
I like this idea. While reading...
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 17, 2012 at 2:47 pm
Yes - reindex will use free space before causing an autogrow. Autogrow can occur if the data is large enough.
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 17, 2012 at 2:35 pm
Try this resource
http://itknowledgeexchange.techtarget.com/sql-server/windows-8-refs-and-sql-server/
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 17, 2012 at 2:13 pm
Your biggest friend will be documentation and stated policies.
This can help too
http://www.quest.com/intrust/pci-compliance.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
January 17, 2012 at 2:12 pm
Viewing 15 posts - 7,081 through 7,095 (of 19,560 total)