Viewing 15 posts - 4,711 through 4,725 (of 49,571 total)
Kristen-173977 (9/21/2015)
GilaMonster (9/21/2015)
Rebuild the clustered index.What happens in this instance if there is no clustered index (i.e. a Heap)?
Then you need to rebuild the heap.
September 21, 2015 at 3:46 am
schaudhary (9/21/2015)
You can use BIGINT Or varchar(Max) Or NVARCHAR(max) for this.
No, please don't suggest storing numbers in a varchar field at all, much less varchar(max). I highly doubt there's much...
September 21, 2015 at 3:11 am
If you need precise, use the Numeric or Decimal data types.
September 21, 2015 at 2:42 am
Rebuild the clustered index.
September 21, 2015 at 2:37 am
.Netter (9/20/2015)
All passwords are encrypted, I would never store them as plain text.
Shouldn't be. They should be hashed, not encrypted. Encryption is reversible, a password once stored should not be...
September 21, 2015 at 2:30 am
.Netter (9/20/2015)
Thanks for the responce, that's very similar to the query I have. I'll add the non clustered indexes to those columns.
Err, no. You'll add A nonclustered index on...
September 20, 2015 at 11:38 am
Jeff Moden (9/20/2015)
GilaMonster (9/20/2015)
The reports use the same DMVs that the OP doesn't want to use because they're since the last compile, not a time frame.
Damn... I keep forgetting that...
September 20, 2015 at 11:36 am
Assuming your query looks something like this:
SELECT UserID FROM Users where UserEmailAddress = @EmailAddress AND HashedPassword = @PasswordHash
then you probably want a nonclustered index on EmailAddress, HashedPassword.
The clustered index...
September 20, 2015 at 6:34 am
robinwilson (9/15/2015)
September 20, 2015 at 3:03 am
What are you trying to do here? Do you just want to see what the form of the message is, or are you testing alerts or similar?
September 20, 2015 at 2:42 am
Jeff Moden (9/19/2015)
nagakula (9/19/2015)
We are trouble shooting a SQL Server high CPU issue and want to know what statements are the expensive ones in terms of CPU usage...
September 20, 2015 at 1:19 am
You'll have to modify the query to get %, but it's not that hard. Probably should also be using extende events, not profiler in SQL 2012, but profiler does still...
September 20, 2015 at 1:18 am
stanlyn (9/19/2015)
Does the default instance's databases automatically show and have to be excluded or something?
No. The default instance's databases show when you connect to the default instance.
Does the user "sa"...
September 19, 2015 at 1:56 pm
You're missing the point. I don't care what port you use (and to be honest, port scanners aren't exactly hard to use, so minor security by obscurity). I didn't ask...
September 19, 2015 at 1:53 pm
Viewing 15 posts - 4,711 through 4,725 (of 49,571 total)