Viewing 15 posts - 1 through 15 (of 60 total)
Apologies. The view used to be a simple reference to the base table. It has been changed since I last looked at it. Seems I was making it more...
April 18, 2013 at 9:59 am
Hi Gail, thanks for posting.
GilaMonster (4/18/2013)Why do you think it has unrelated tables in? )
Because those tables were not in the query. Why on Earth would other tables need to...
April 18, 2013 at 7:56 am
You can apply logic to what you think the execution plan will look like, but in my experience trying to second guess the Optimizer is notoriously difficult, as my next...
April 18, 2013 at 5:07 am
I granted CREATE ANY DATABASE & ALTER ANY DATABASE permissions to a user but that did not allow him to restore databases.
However, adding him to dbcreator did.
System stored proc...
April 11, 2013 at 10:19 am
We had this error too.
Basically all users should be able to access these views as SELECT rights are granted to public. There must be a specific DENY for this...
October 30, 2012 at 4:42 am
Title was full of promise, but we need more.
Ideally, we want to be able to determine what statements caused the log to grow so suddenly (and who issued the statements)...
February 16, 2012 at 7:25 am
Well done Scott. This has been doing my head-in.
We have a user with his own domain account & granted the db_ddladmin role in a database. He can alter objects in...
February 10, 2012 at 9:46 am
This should do it I think ;
select distinct object_name(object_id) from sys.partitions
group by object_id, index_id
having COUNT(*) > 1
Basically a table and its indexes are represented in sys.partitions. For...
December 6, 2011 at 10:58 am
Getting this error running an INSERT statement with (TABLOCK). Resulting in a Stack dump. The table is NOT compressed/replicated, CHECKDB does not reveal any errors. Using SQL Server 2008...
October 14, 2011 at 9:32 am
shifty1981 (9/12/2011)Where do you find that log info?
In SQL Server's Logs (Management node)
September 22, 2011 at 8:59 am
You wrote ; "Total Memory means how much memory SQL is using"
Just saw this on msdn ;
Target Server Memory (KB)- Total amount of dynamic memory the server can...
September 22, 2011 at 8:57 am
What is the purpose of
[font="Courier New"]select id, xtype from master.sys.sysobjects[/font]
is sys.objects not sufficient ?
Also would it better to change the join order i.e. if we are after...
September 22, 2011 at 8:00 am
Alter Proc spLogin_OwnedObjects ( @login as SYSNAME )...
September 16, 2011 at 10:58 am
The server log should tell you if you have memory pressure.
We have ;
"AppDomain 9 (mssqlsystemresource.sys[runtime].8) is marked for unload due to memory pressure."
Total = Target
So I have...
September 9, 2011 at 10:42 am
Word of warning : if the history has been purged/deleted then sysjobhistory will not display the same data as "Job Activity Monitor" i.e. "Job Activity Monitor" will display a...
August 12, 2011 at 10:39 am