Browse by Tags

find sql users and roles assigned to my databases

thanks to this article for the base script. i needed to get a list of all users and the roles they had in each db. this script is great in that you can use the raw base script (mine is slightly modified) and list things for every object instead of just at the db level. in my case and in most people's...

Posted to roy ashbrook (Weblog) by royashbrook on 09-05-2008
XML in SQL server

Question From NTSSUG - http://northtexas.sqlpass.org I am working on an application that has object data mapped to tables. The mapping was done many years ago, before the likes of Hibernate came along. It basically maps a class to a table. Object properties with multiple values get their own tables....

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 09-05-2008
Huston TechFest 2008

I will be giving my SQL CLR talk at the Houston TechFest on Saturday September 13 at the University of Houston. It will be a great event.

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 08-20-2008
Allow Remote Connections & Linked Servers

Got the following question via the North Texas SQL Server UG ( http://northtexas.sqlpass.org/ ) mailing list. Hi, I am trying to add linked server in SQL Server 2005 (let say server1)for a another remote server(server2) which is also SQL Server 2005. Do I need to create a login on the server2 in order...

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 08-13-2008
The Top Ten Reasons to Attend the PASS Summit 2008

I read an article on SQL Server Central about the "The Top Ten Reasons to Attend the PASS Summit 2008" ( http://www.sqlservercentral.com/articles/SQLServerCentral.com/62979/ ) and I would like to propose one more. I will let you decide if it is #1, #11 or somewhere in the middle. If you attend...

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 08-13-2008
'net' command (net user, net localgroup, etc)

it's depressing to me how many people that i run into today that have an excrutiatingly limited knowledge about the command line in windows, and yet they are considered experts on the platform. that aside, i figured i would share a couple of very simple uses. something people ask a lot is what domain...

Posted to roy ashbrook (Weblog) by royashbrook on 07-29-2008
SQL Saturday Jax May 3 2008

Tomorrow will be the long awaited third installment of SQL Saturday in Jacksonville FL. I want to thank Brian, Andy and the team for all their hard work putting the event together. If you attended my talk or just want to see some cool stuff about using the CLR in SQL Server check out my presentation...

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 05-02-2008
Need to delete lots of data, do it in small chunks

By adding a top clause to your delete statement you can delete a chunk of records at a time. By combining it with a while you can put it in a loop and wipe the entire table. WHILE EXISTS ( SELECT * FROM Foo ) BEGIN DELETE TOP ( 100 ) FROM Foo END Had someone send me an email telling me that it might...

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 04-25-2008
Drop Me!

I was trying to get rid of all the objects (tables, procedures, views) in my database and whipped up this little script and while it is far from perfect it is well worth sharing. . . SELECT CASE WHEN type = 'P' THEN 'DROP PROCEDURE ' + name WHEN type = 'U' THEN 'DROP TABLE...

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 04-12-2008
how can i get some performance statistics on my stored procedures in sql2005?

select case when dbid = 32767 then 'resource' else db_name(dbid) end [db_name] , object_schema_name(objectid,dbid) [schema_name] , object_name(objectid,dbid) [object_name] , sum(usecounts) [executions] , max(max_execution_time) [last_execution_time] , sum(total_logical_reads) [total_logical_reads...

Posted to roy ashbrook (Weblog) by royashbrook on 03-21-2008

Page 1 of 9 (82 items) 1 2 3 4 5 Next > ... Last »