Viewing 15 posts - 5,296 through 5,310 (of 49,552 total)
They're cheating.
They're actual questions taken from the exams in violation of the NDA which all exam takers accept. Using them or distributing them can result in your certifications being revoked...
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
July 16, 2015 at 3:33 am
Using something like sp_MS_foreachDB or a custom written cursor to loop over all databases, inserting into a temp table. Then select from a temp table at the end.
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
July 16, 2015 at 3:10 am
Bharatvip (7/15/2015)
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
July 16, 2015 at 2:57 am
Using something like sp_MS_foreachDB or a custom written cursor to loop over all databases. sys.partitions and sys.objects are specific to the current DB.
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
July 16, 2015 at 2:52 am
Don't use Task Manager to look at SQL's memory. It often lies.
In this case though it's probably right. 1GB for the buffer pool and 600MB for the non-buffer portion (thread...
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
July 16, 2015 at 2:50 am
Put it in the database. Putting it in your app won't help when other apps, spreadsheets, MS Access, etc are connected to the DB, when the app is changed or...
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
July 16, 2015 at 2:40 am
That counter has has no value at all.
You can have a server under severe memory pressure with that counter still sitting 99%. Ignore it, use other, more useful, counters.
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
July 16, 2015 at 2:38 am
Yes, with a trigger, however running long processes from a trigger is a really bad idea. Probably better to put the report code in a SQL job and 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
July 15, 2015 at 9:26 am
Hehehe. That's the kind of thing that, when I'm optimising procedures, I tend to take out.
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
July 15, 2015 at 9:04 am
karthik82.vk (7/15/2015)
Is there any way to do it in sql itself?
No. SQL is a database engine, not a language processor
Are there any tools outside SQL that can be used for...
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
July 15, 2015 at 8:37 am
shirish_padekar (7/15/2015)
3. I also found that "Auto Close" property is "True" for this database, should I change it to "False" ?
Yes. It's not related to your question, but it's...
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
July 15, 2015 at 8:20 am
Yes, asking people to write an efficient query when you don't entirely know what you need is a really good way to get a useless answer....
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
July 15, 2015 at 8:19 am
KGJ-Dev (7/15/2015)
Hi Gail,When i see the table structure and question, i am also confused with the same questions.
If you don't know what you want, there's not much chance we're...
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
July 15, 2015 at 8:18 am
Could you be a little clearer as to what you want? If 32k entries all have the same datetime stamp and same load_id, how do you determine the 'first' row?
Or...
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
July 15, 2015 at 7:02 am
In addition, since this is a simplification of the actual problem, it's possible (though impossible to tell for sure) that a temp table isn't necessary at all. Are you able...
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
July 15, 2015 at 6:56 am
Viewing 15 posts - 5,296 through 5,310 (of 49,552 total)