11,118 reputation
23166
bio website
location Connecticut
age
visits member for 3 years, 6 months
seen 2 days ago

I'm a dude.


2d
comment Why do nonclustered Indexes use clustered indexes instead of the table data pages directly?
Well the leaf nodes may in fact move if the CI changes...that's a bad practice but it's possible to do.
2d
answered Why do nonclustered Indexes use clustered indexes instead of the table data pages directly?
Nov
17
comment SQL Procedure of signing up
We need a LOT more detail to be able to help here. When you say "procedure" do you mean stored procedure in the database? What's the interface? What is the table structure? At face value this is an extremely simple INSERT statement, what part of it is causing you an issue? Do you need to store the password or the hash of the password?
Nov
17
awarded  Popular Question
Nov
13
comment Keep track of time intensive stored procedure with prints
For your error, you can't pass an int in to the message - it thinks you're passing in a message id. Try making @MsgStr varchar(100) = CAST(@Cur_id as varchar(100)) instead.
Nov
13
answered Keep track of time intensive stored procedure with prints
Nov
10
comment Impact of Service Broker on Server Performance
You can't really trust waits for broker operations since nothing is waiting on them. You will probably see a ton of broker waits, but it's not blocking any other processes so it's not impacting your overall server unless you get some really heavy processing doing tons of XML shredding or data access.
Nov
10
comment Impact of Service Broker on Server Performance
Personally I think performance aside you want it as part of the DB. Otherwise, how can you migrate a database to another server or instance?
Nov
10
comment Impact of Service Broker on Server Performance
The impact is going to depend entirely on how much work your queue processing procedures are doing. One queue vs 200 isn't necessarily a fair comparison since really it's one incredibly busy queue vs 200 not very busy queues - in either case you're processing the same number of transactions.
Nov
6
comment Best design to handle multiple query keys
@MinimeDJ Properly designed and normalize relational databases work plenty fast with data sets many orders of magnitude larger than they one you are talking about. What WON'T scale is keeping all the data in one table for a variety of reasons. Asking for help and then saying you don't think the solutions will work for no apparent reason is not really a productive course.
Nov
6
revised Best way to handle multiple query keys
deleted 135 characters in body; edited title
Nov
5
comment about latest row in sql server
May as well say you want to know how fast your car is going and how far it went without a speedometer or odometer. Timestamps and incrementing PKs ARE THE TOOLS that you use to determine this information.
Oct
29
comment Filter table before join
Is there an index on your temp table? If you have more than a couple thousand rows it's probably worth it to index a JOIN key.
Oct
23
revised Database is happily available even during log growth?
added 3624 characters in body
Oct
23
revised Database is happily available even during log growth?
deleted 3763 characters in body
Oct
6
comment Should these two indexes suggested by the SSMS missing index feature be combined?
Caveats with filtered indexes - stats may not stay up to date without maintenance, and you need to use "standard" values for some settings like QUOTED IDENTIFIER and ANSI NULLS. These are small issues but if you have the settings wrong in a session that inserts into the index, the insert will fail.
Oct
3
comment T-SQL - OPTION (FAST x) and trace flag 8722
DBA.SE - More SQL Server MVP's per capita than the PASS Summit.™
Sep
30
awarded  Explainer
Sep
29
comment rebuild on clustered index, why does datasize shrink?
Are you determining data size from the file size?
Sep
25
comment Whats wrong with my index?
I'm not sure about MySQL, but in for instance SQL Server when you apply a function to a column in the WHERE clause (such as your date() function) it negates the use of indexes because it forces a table scan.