Viewing 15 posts - 19,906 through 19,920 (of 49,552 total)
Why complicate matters? It's the number of cores available to SQL Server, SQL doesn't care about the number of sockets.
Also consider measuring inaccuracies.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 2:22 pm
CPU time = total time spent by CPU processing the query. Elapsed time = total time between query starting and query completing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 1:49 pm
mtillman-921105 (3/5/2012)
I wish I could cook Chinese (or Japanese!), but we have an electric oven and I'm told that you really need gas to get the Wok hot enough.
I cook...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 1:47 pm
guerillaunit (3/5/2012)
I'd like to divide the statement into separate subscripts because the subscripts need to be processed in sequence.
Not following.
If you have a set of statements (like in the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 1:45 pm
jigsm_shah (3/5/2012)
Now when I write the following query,it does not return any rows.
There are Items with ItemTypeId...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 12:19 pm
What do you mean by 'separate scripts'? What's the goal here, what are you trying to achieve?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 10:16 am
Then that's probably the table that you want to be joining to. Any time you have a situation where you join duplicate values to duplicate values you'll get the 'row...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 9:11 am
Yes, it's absolutely possible
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 9:08 am
You can't have a USE in the procedure, and the first GO will be the end of the procedure.
GO is not a T-SQL command. It's a client tool batch-breaker. It...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 8:42 am
Well 2x12 gives 8 more cores to do work. My only concern would be the cache, a 12 core processor should have a lot more L2 and L3 cache than...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 8:40 am
Restore of master should be very fast (practice on a dev machine so you know how it works), also this likely isn't absolutely critical to fix if there's not much...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 8:38 am
Eric M Russell (3/5/2012)
If you're thinking about implementing some solution that involves auditing events, then consider extended events.
Though since this is the SQL 2000 forum, it needs mentioning that Extended...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 8:37 am
I would recommend restore from a clean backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 8:26 am
The 2x12 gives you 24 cores vs the 16 that the 4x4 would, and if you're licensing by processor as opposed to CAL it's half the licensing costs as well.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 8:25 am
ddafunk (3/5/2012)
what is the sql vhd?isit like a virtual server thingy
No such term.
A VHD is a virtual hard drive used in virtualisation products. Nothing to do with SQL Server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2012 at 7:12 am
Viewing 15 posts - 19,906 through 19,920 (of 49,552 total)