Viewing 15 posts - 2,956 through 2,970 (of 7,191 total)
Jon
This sounds fairly easy, but you haven't provided us enough information. Please post a CREATE TABLE script for each table involved, sample data in the form of INSERT statements...
November 24, 2015 at 4:43 am
There's two ways I'd recommend:
(1) Set up a Central Management Server (CMS) in SSMS and then register all the servers in your list in a group under the CMS. ...
November 24, 2015 at 4:41 am
You've got half a dozen "database" keywords in the second half of your query. What are they for? Run your query in a query window to check that...
November 23, 2015 at 8:26 am
That's not the same query you posted earlier. What is "loo" - is it a linked server? If you're querying a remote server then the four-part naming convention...
November 23, 2015 at 4:37 am
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
Viewing 15 posts - 2,956 through 2,970 (of 7,191 total)