A team mate of mine manage to bring the restore time back to the initial speed by using this 2 parameters during the restore MAXTRANSFERSIZE & BUFFERCOUNT. However none of us knows why the restore time slowed down in the first place as our checks with system admin guys (server, storage, network & security) leads to dead end with all pushing back the responsibility to us by saying nothing was changed from their end. Since we do not have any support acc with Microsoft, we can't raise case with them thus using this parameter is a workaround ..read more

You don't have anybody building databases in Access do you? That's where I'd look.  My guess is that someone has permissions on your Master Data Services instance that he shouldn't. "tbl" is "Hungarian" notation for a table in Access, so my guess is that it either came from there, or you have an Access developer playing with one of your SQL Server instances ..read more

Rod at work wrote: We all must work with technologies that are at best 15 years old. Would upper management actually realize if you used .Net 8 instead of .Net 2? Would they realize if you asked for a test vm and put the Data API builder on it? etc ..read more

I also want to say that I really appreciate people who bought Teslas years ago, as I believe that the early adopters paved the way for EVs to be popular in the US now. Also, my friend recently purchased a plug-in hybrid.  Her plug-in hybrid operates on all-electricity for all her daily, in-city driving.  If she needs to take a trip to another city, going past the battery range, the gas kicks in.  She plugs the car into the regular garage outlet at night, needing no special plug-in.  I'm committed to having my next vehicle be a full EV (if I can find one to my specifications ..read more

Fun article, as I'm passionate about EVs and enjoy learning new things.  However, the reason I don't have an EV right now is because there aren't any on the market that I want.  Even back when I had Tesla stock and didn't hate Musk with a passion, I didn't want a Tesla for a variety of reasons.  I understand that we are on the verge of lots of new electric vehicles options coming in the next few years though (assuming the current administration doesn't mess that up), and I'm super excited for those opportunities. All of which is to echo some of the previous comments that sometim ..read more

thx phil i believe that custom setting was ssrs automatically setting it (the rt click on report) . none of my objects is wider than the body but my textbox heights are set such that you cannot read the "value" anymore in designer.  The most common font i have in those boxes is 10 Segoe UI, with a height of .15.    i squeezed them to get the text boxes involved to seem closer at render time.  i wonder if that's the culprit.   the report's textbox spacings looks fine at render time. This reply was modified 11 hours, 51 minutes ago by  stan ..read more

DROP TABLE IF EXISTS #view_names;CREATE TABLE #view_names ( view_name nvarchar(100) PRIMARY KEY );INSERT INTO #view_namesVALUES('>--->YOUR_VIEW_NAME_TO_SEARCH_FOR_GOES_HERE<---<')/*, ('another_view_name_could_go_here') ... */DROP TABLE IF EXISTS #is_views;SELECT TOP (0) *INTO #is_viewsFROM INFORMATION_SCHEMA.VIEWS;EXEC dbo.sp_MSforeachdb 'USE [?];INSERT INTO #is_viewsSELECT *FROM INFORMATION_SCHEMA.VIEWS VWHERE EXISTS(SELECT * FROM #view_names vn WHERE vn.view_name = V.TABLE_NAME)'SELECT *FROM #is_viewsORDER BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME SQL DBA,SQL Server M ..read more

"this is not enough of an annoyance for most people to seriously start looking at something like PostgreSQL" Most? Probably still true. But they might want to re-evaluate their over-confidence and disdain for users. Postgres growth numbers are incredible. We're seeing more and more well-known MSSQL leaders embracing postgres. Open source growth in general, and movement to the cloud, are  are increasingly pulling businesses away from the Microsoft stack ..read more

RedGate SQL Search is an incredibly valuable tool ..read more

thanks both for replies, most helpful; will definitely hardcode the numbers here, much better; thanks to Ed B as well for identifying where the problem was: my NUMBERS table is/was a Memory-optimised table, for which the indexing is different from a conventional physical table, meaning that when i do a simple un-ordered select, (or a select top n *), the numbers returned are largely unordered, with the first 51 being 4045-4095; as verified by Ed B, using a conventional physical clustered-indexed numbers table, it works as expected; thanks again ..read more