Viewing 15 posts - 5,911 through 5,925 (of 13,459 total)
unless you already have created a trace which is capturing that information, it's not available anywhere. SQL server does not keep track of successful logins unless you enabled it or...
Lowell
February 22, 2012 at 8:33 am
Different application hitting the server, or the identical application and same traffic?
It's been mentioned at least half a dozen times that SQL using all the memory is perfectly normal, but...
Lowell
February 22, 2012 at 6:58 am
AWE settings have no affect on 64 bit isntallations.
by default, SQL will consume 100% of the memory, or up to 100% of the maximum you set.
What can be a little...
Lowell
February 21, 2012 at 2:12 pm
Eugene Elutin (2/21/2012)
try this:http://www.sqlservercentral.com/articles/Best+Practices/61537/
should help to get the most relevant answer in minutes.
link from above updated: the link had an extra
character in it after the forum rendered...
Lowell
February 21, 2012 at 9:57 am
what events are you using?
my traces usually have both SQL:BatchCompleted and RPC:Completed
RPC:Completed will return code when a proc is executed, whether in TSQL or when a command object has...
Lowell
February 21, 2012 at 9:54 am
and another way, via an extended stored proc:
EXEC master..xp_logininfo
@acctname = 'mydomain\lowell',
@option = 'all' -- Show all paths a user gets his auth from
go
EXEC master..xp_logininfo
...
Lowell
February 21, 2012 at 9:20 am
from your query so far, i couldn't infer any datetime columns exist that you could pull the year out of.
there is a YEAR function that will get the year of...
Lowell
February 21, 2012 at 9:14 am
sambireddy chirra (2/21/2012)
it's possible,i tried its working.
I call shenanigans.
If you tried it, you'd report the same performance hit I was talking about.
Performance on a page like this sucks., and...
Lowell
February 21, 2012 at 5:03 am
none.
no performance impact, because the mail command is asynchronous...the mail is queued to the service broker, and it processed outside of the transaction;
On a recent email campaign, i queued about...
Lowell
February 20, 2012 at 7:37 pm
the DDL of the table can help us solidly determine why the index gets skipped;
for example:
one wild guess: if tbl3.ColA and tbl2.ColA in your example below are not the same...
Lowell
February 17, 2012 at 2:35 pm
to find a datavalue, you'll have to use a cursor or it's equivalent of building a SQL command for each varchar/char column and executing it.
I've done this before, so let...
Lowell
February 17, 2012 at 1:15 pm
i think if your animated gif is over a certain size, or gets resized automatically, the format is not gif89a? (animated?), it's a different gif;
double check you r gif you...
Lowell
February 17, 2012 at 9:50 am
it goes back to what you said you want to do...I might be misunderstanding.
I thought you said you said both find anything and find anything except...
will something like this work...
Lowell
February 17, 2012 at 9:18 am
krishnakhanna (2/17/2012)
Name ...
Lowell
February 17, 2012 at 8:46 am
both SQL and Oracle support pattern matching for any character:
select * from YourTable
where YourColumn like '%H_M%'
SQL supports a type of regular expression like this:
select * from YourTable
where YourColumn like...
Lowell
February 17, 2012 at 8:30 am
Viewing 15 posts - 5,911 through 5,925 (of 13,459 total)