Viewing 15 posts - 2,191 through 2,205 (of 13,469 total)
i've used Process Explorer from sysinternals in the past
, as well as OpenedFilesView
http://technet.microsoft.com/en-us/sysinternals/bb795533.aspx
November 17, 2014 at 7:46 pm
it depends on what you want to monitor, of course.
so general tools i'm aware of are like this one...
Dell's Spotlight Freemium is pretty good for free, i kind of like...
November 17, 2014 at 5:19 am
and the issue is often not really related to the number of rows, but if it can be accessed effectively and with reasonable speed.
that starts bringing in things like design,...
November 14, 2014 at 2:11 pm
you probably want to cleanup line2 as well;
i think it's something like this:
CREATE TABLE #address(AddressID int, Line1 varchar(100), Line2 varchar(100) )
INSERT INTO #address
SELECT '1234','123 Main St.','Suite 2000' UNION ALL
SELECT '6596','2400...
November 14, 2014 at 12:52 pm
looks like you posted before you did anything more than pasting some sample data.
what is the question?
since your new, i've reformatted your paste into consumable format...then anyone can grab your...
November 14, 2014 at 12:12 pm
could it be because the SSMS settings is defaulting to a 256char display limit for a column length, in order to conserve resources?
on both the Results to Grid and Results...
November 14, 2014 at 11:32 am
how can another procedure consume the data of a dynamic procedure, if it doesn't know what columns would be included?
typically, you create a temp table and insert into it, ie:
CREATE...
November 14, 2014 at 7:50 am
Perry Whittle posted a nice script for scripting all database permissions in this thread;
I've adapted that one to my own needs:
the important part there is probably the nested roles, plus...
November 14, 2014 at 6:25 am
according to this msdn, it seems like the range you are choosing for your LSN start and end are invalid, and it raises that exact error:
could it be that your...
November 13, 2014 at 8:33 am
you've got to differentiate between LOGIN and ACCESS
a login occurs once, and might have a reference a database in it's connection string, but it never "logs into" a database.
After...
October 17, 2014 at 10:37 am
does your query use the NOLOCK hint?
October 17, 2014 at 10:32 am
onixsoft (10/1/2014)
Lowell (10/1/2014)
no "app" is needed for this, as the data entry for any app that tried to...
October 1, 2014 at 2:08 pm
you are overthinking this if you think you need an app for that.
no "app" is needed for this, as the data entry for any app that tried to do this...
October 1, 2014 at 8:46 am
either drop the table once at the very top, don't use two different statements.
also, you could modify the query to be a single one with a case statement:
CREATE PROCEDURE MyProc...
September 26, 2014 at 6:57 am
writing to disk requires either an external application, like somethign written in .NET , or using bcp or a CLR object to help you do it.
there's no native way ...
September 24, 2014 at 8:11 am
Viewing 15 posts - 2,191 through 2,205 (of 13,469 total)