Viewing 15 posts - 16 through 30 (of 195 total)
J Livingston SQL (10/12/2013)
??....why the "shouting"?
No, m=not shouting.. just went Wacko...:w00t:
as i thought member 'motherstechbpo' provided me script.. but he rather posted his jobs and vacancy info 😀
October 12, 2013 at 8:08 am
:w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t:vv
Thanks for the SCRIPT:w00t::w00t:
October 12, 2013 at 7:15 am
I downloaded Brents script.. its huge & didnget which to use from them..
can anyone help me with scripts one by one for below need 🙁
1) Script to Identify what Indexes...
October 12, 2013 at 5:30 am
Hi Beatrix, i have limited access to Links out .. Would appreciate if you share any of such if you have downloded 🙁
October 10, 2013 at 9:45 am
Beatrix Kiddo (10/10/2013)
There's a good free pdf book here called SQL Server Maintenance Plans[/url], and it has some nice sections on indexes, especially pages 106 onwards.
It ask's for payment :w00t:...
October 10, 2013 at 8:45 am
Thank you hansi..
Please check my new post.. need some more scripts on urgent basis... if u can help 🙂
October 10, 2013 at 4:55 am
Thanks Sean & Gail for suggestions & query.. it worked..
We caught the Table where we need to do the change 🙂
Appreciate your prompt replies.. god bless u all..
October 9, 2013 at 9:08 am
Sean Lange (10/9/2013)
OnlyOneRJ (10/9/2013)
Server name- TESTXXAB
Database name - TEST_USER
This DB have many Tables
Now we have to write a query which will search the data in the tables which...
October 9, 2013 at 8:48 am
Lolzz Andrew... Thanks Gail....
Now they have got a DBA who knows about Backup/restore, logins, user access, Maintenenace tasks etc.. but no knowledge of performance tunning...
they are from different department so...
October 5, 2013 at 4:00 am
Right Andrew.. but they will not do so.. they have asked a developer to perform this task:-D
October 4, 2013 at 9:48 am
SQLJim88 (9/19/2013)
You can run SP_who2 with "View Server State" permissions.grant ALTER ANY CONNECTION to USER, will allow you to kill user sessions.
I have created a Group Named - "Dev_Team"
What will...
September 19, 2013 at 7:57 am
Viewing 15 posts - 16 through 30 (of 195 total)