HIT And MISS

Nov 23, 2005

Hi Guru,

My profiler trace does not display SP:CACHEMISS event, even thought I
drop store proc, clear both data cache and buffer cache but still does
not work.

Every thing works fine like: cachehit,
cacheinsert,cacheremove,executecontexthit etc...

Is there any special option that I need to turn it on?

Please help,

Thanks,
Silaphet,

View 1 Replies


ADVERTISEMENT

What Do You Miss On SSIS?

Jun 2, 2006

Maybe a silly thing but can you imagine that the tasks showed Heigh,Left, Top location properties as whether they were VB's control?

View 4 Replies View Related

I Miss The Old Query Analyzer.

Aug 4, 2006

In QA from MSSQL2K5, is there a way Cntrl + W through the windows like there way in MSSQL2K5? I've tried and tried to find this type of setting and this is driving me nuts! :mad:

TIA, cfr

View 8 Replies View Related

Miss Tables In Replication

May 3, 2006

I have setup a transactional replication from oracle to MSSQL2005. One of the publication includes 26 articles but I found that there are only 24 articles replicated to the subscriber DB. I found that the repldata folder includes only files for 24 articles only. Besides, I double check the publication properties, totally, there 26 articles. Please advise. Thanks in advise.

View 2 Replies View Related

I Miss MS Access Crosstabs In SQL-Server ;-)

Apr 25, 2005

Hi there...
im my DB there is a table. Something like
Who, Value1, Value2, ...
John, 1, 2
Jim, 2, 2
Bob, 1, 1
Jack, 0, 0
Mike, 1, 1
...
 
Now i want to have as a result of a query:
Valuefield, 0, 1, 2
Value1, 1, 3, 1
Value2, 1, 2, 2
as the count of rows that equals 0, 1 or 2 to each column...
 
I know the select-case-statement in SQL-Server, but how do i get the columnnames in the first column??? I have 28 columns like that in my table...
 
hope you can provice help...
 
kind regards,
Cappu
 

View 5 Replies View Related

Permissions Question.. (hey, Didja Miss Me?)

Jul 1, 2004

Hi all,

Wow...since I've been gone, the search feature is apparently working again! Kewl!

However, after doing a search and not finding anything pertaining to my current issue, here I am again :D

I access a table on a linked server/database apart from my application's DB.

Every day, a process on the other server/DB drop and recreate the table....which, of course, zaps my user permissions. I then have to go into the Enterprise Mgr and re-enable my SELECT access to the table.

My question is this: Is there a way to auto-magically set my user ID on the linked server to give me access to the table without having to go in explicitly on a daily basis and re-enabling my UID Access rights.

This is the only table my user ID has been given access to on the remote server, so I am not able to simply set up my user ID on the remote system to "allow everything"

Am I missing something obvious? Do I have to create a SP on the remote server to do a daily GRANT SELECT ON Remote_Table TO Paul_Dammit after the table is rebuilt each day???

Suggestions?



It gets

View 3 Replies View Related

Do You Miss Query Analyzer In SQL 2005?

May 15, 2007

I tried. I really did to adapt to using Management studio as a replacement, but I just can't make the jump. I went ahead and installed SQL 2000 QA and have gone back to using it for ad-hoc query support and other routine SQL tasks. For me the main thing is the "Notepad-esque" lightness of QA compared to the heavier SQL tools that allows me to quickly open a SQL script file and get to work on it quickly. I appreciate an integrated tool, but I would like to see future versions allow you to use it either as a standalone or within integrated platform. Am I alone in this? Anyone else feeling this pain?

View 6 Replies View Related

Miss Match Between Column Type In A Cursor. Msg 8114, Level 16, State 5

Nov 16, 2006

hi

I have a float column . only in cursor I get a type missmatch.

does any one knows it ?

the error

Msg 8114, Level 16, State 5, Line 14

Error converting data type varchar to float.

the code

DECLARE @RON_FLOAT FLOAT

DECLARE RON_CURSOR CURSOR FOR

SELECT RON_FLOAT

FROM RON_TABLE1

OPEN RON_CURSOR

FETCH NEXT FROM RON_CURSOR

INTO @RON_FLOAT

WHILE @@FETCH_STATUS = 0

BEGIN



PRINT 'VALUE IS ' + @RON_FLOAT

FETCH NEXT FROM RON_CURSOR

INTO @RON_FLOAT

END

CLOSE RON_CURSOR

DEALLOCATE RON_CURSOR



the code for the table

CREATE TABLE [dbo].[RON_TABLE1](

[RON_FLOAT] [float] NULL,

[RON_CHAR] [nchar](10) COLLATE Hebrew_BIN NULL

)

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved