Viewing 15 posts - 2,956 through 2,970 (of 7,187 total)
KcV (11/23/2015)
i got about 60 indexes in this tableDMVs ?
what is it ?
kindly guide me. pls
Dynamic management views. Here's one for index usage. If I may...
November 23, 2015 at 4:23 am
The same way you'd send the results of any other query. It only has one result set, as you mention, so I'm not sure what you're struggling with?
John
November 23, 2015 at 4:16 am
If you're getting PAGEIOLATCH_EX waits then that's often an indicator of problems on your disk. Is your disk shared with any other applications, file shares or other SQL Server...
November 23, 2015 at 4:01 am
You either need to supply a value for the @execute_query_database parameter, or qualify the Users table with the database name in the query.
John
November 23, 2015 at 3:49 am
Thanks Gail. That's just as comprehensive as anything I was planning! I repeated your test but I restricted the lookup tables to 250 rows, since that's probably around...
November 23, 2015 at 3:41 am
The first place to look when you're doing performance tuning is the execution plan. If you'd compared the plans for the two queries, you'd have noticed they're identical and...
November 23, 2015 at 2:42 am
Look up sp_whoisactive, create it on your server, then use it to see what's happening while your INSERT statement is running.
John
November 23, 2015 at 2:36 am
Oops, you're quite right! I'd still be interested to know what the performance difference is - I can't see it being significant. I shall post back if I...
November 23, 2015 at 2:13 am
Sergiy (11/22/2015)
That is right, but the thing is - GUID was never meant to be "for a human eye".
It is a machine-generated set of bytes serving internal machine purposes.
And we...
November 22, 2015 at 5:42 pm
Sergiy (11/21/2015)
Those series of letters you see on the screen as GUID's are not stored in database, like series of...
November 22, 2015 at 5:07 am
Sergiy (11/20/2015)
First - GIUD is not made of characters. It's a 16 bytes long binary value.
I thought you'd say that. You're right, but it's still rendered as a series...
November 21, 2015 at 2:46 am
David
You could dump what you need from Inserted and Deleted into a temp table and see whether you can access it from there. Be very careful what you do...
November 20, 2015 at 4:42 am
Good point. Wouldn't it be best, though, to use an international standard where it exists, even if it's in a different alphabet from the rest of the database? ...
November 20, 2015 at 4:35 am
That's a good catch, Anthony. In case it isn't that, I'd be tempted to write it out longhand, 26 times, just to avoid all those confounded quotation marks. ...
November 20, 2015 at 4:23 am
Sergiy (11/20/2015)
Sean Lange (11/19/2015)
I would hope that for lookup tables like states and currencies you don't use a guid as the primary key. The ANSI abbreviation is an excellent choice...
November 20, 2015 at 3:04 am
Viewing 15 posts - 2,956 through 2,970 (of 7,187 total)