Power BI Desktop

2005-03-23

RE: Select only stand alone statistics to drop

by Shoe

MSSQLTips.com

I found the problem!!!!Article Id number 293177.The people who wrote our database program ran a lot of Index Tuning Wizards. These temporary stats never left and are creating update loops on my server. Guess how many...over 50! It's those stats with the hind_% name.I want to thank you two. I have learned much today.

2005-03-02

RE: How to get available memory using SQL

by Ninja's_RGR'us

SQLServerCentral.com

It's not a table : run this in the master table Select objectproperty(object_id('sysperfinfo'), 'TableIsFake') It will return 1. This means than when you query that table, Sql server meterializes it so that the query can execute, but this information is never actually kept on the hd like a real table. checks BOLS : objectproperty::TableIsFake

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-03-02

RE: Need function to match elements in one table to another

by Schalk-Lubbe

SimpleTalk

You could also do a left outer join, and see whether any records are returned. If none are returned, it means that all the records from table A are in table B Regards Schalk

2005-01-28

RE: Logins

by Dave-175556

SimpleTalk

Hi,I had same problem about orphaned users, i just ran update query on the sysusers table for all the databases for orphaned users to update their sid to correct one, but it's not advisable to update system table directly until you know about it. so it is preferred to use sp_change_users_login. One problem i am […]

2004-12-15

RE: Looping through tables

by Ronald-Ward

SimpleTalk

Michael thank you for the reply.I thought i was being clear in what it was I was trying to do, however it is obvious that I was not. Let me try again..I have a set of tables that are prefixed with ae_dtnn and ae_dlnn. the ae_dt tables contain index information as well as the docid. The […]

2004-12-03