May 26, 2017 at 11:48 am
Luis Cazares - Friday, May 26, 2017 10:16 AMSo, today I got this beauty for deployment. Things like these make me want to either slap or choke the developers.
CREATE TYPE [dbo].[udtbl_ParentSomeColumnXXID_ParentSomeOtherColumnXXID_ChildSomeColumnXXID_ChildSomeOtherColumnXXID_FlipFlag] AS TABLE
(
ParentSomeColumnXXID INT,
ParentSomeOtherColumnXXID INT,
ChildSomeColumnXXID INT,
ChildSomeOtherColumnXXID INT,
FlipFlag VARCHAR(1)
)
In medieval times this would be punishable by drawing and quartering.
Or he should have his intellisense and copy paste disabled whenever he needs to use this table.
May 26, 2017 at 11:57 am
Ed Wagner - Friday, May 26, 2017 10:03 AMWe all have our areas of specialty, but I'd think backup and recovery would be primary topics for most DBAs.
Backup and restore should be #1, always. Native as well as any tooling you use.
Then security, then anything else your org needs, but always get the data back first.
May 27, 2017 at 9:54 am
BrainDonor - Friday, May 19, 2017 7:06 AMWho's going to SQL Saturday Manchester?
I hope I am - but there's a risk I won't make it.
Tom
May 27, 2017 at 9:58 am
Luis Cazares - Friday, May 19, 2017 8:35 AMEd Wagner - Friday, May 19, 2017 8:02 AMGrant Fritchey - Friday, May 19, 2017 7:49 AMIs anyone else experiencing this? When I type into a post, as I'm doing now, When I hit enter to put a new line
t moves my cursor so that you see what happens with the "I" being in the wrong spot IurtherF
Further, when I fix it, for some reason the browser shows that first word as being misspelled.
I'm using Microsoft Edge. Just curious if it's just me or if others see it too?
I haven't seen that specifically, but there is still some weirdness in the post window. The cursor trailing behind the typing location after deleting words has to be the most annoying. Another thing is that after pasting, the cursor disappears as if the text box lost the focus. I generally use Firefox, but have confirmed it happens in IE as well. Now you've got me wanting to try Edge. 😉
I've seen the trailing cursor quite often. It's easily solved by pressing delete once. The pasting has so many problems, including the removal of spaces.
I have quite a few problems since the new system. Tried switching to Edge but that made it no better, so switched back to Firefox.
Tom
May 27, 2017 at 6:07 pm
TomThomson - Saturday, May 27, 2017 9:58 AMLuis Cazares - Friday, May 19, 2017 8:35 AMEd Wagner - Friday, May 19, 2017 8:02 AMGrant Fritchey - Friday, May 19, 2017 7:49 AMIs anyone else experiencing this? When I type into a post, as I'm doing now, When I hit enter to put a new line
t moves my cursor so that you see what happens with the "I" being in the wrong spot IurtherF
Further, when I fix it, for some reason the browser shows that first word as being misspelled.
I'm using Microsoft Edge. Just curious if it's just me or if others see it too?
I haven't seen that specifically, but there is still some weirdness in the post window. The cursor trailing behind the typing location after deleting words has to be the most annoying. Another thing is that after pasting, the cursor disappears as if the text box lost the focus. I generally use Firefox, but have confirmed it happens in IE as well. Now you've got me wanting to try Edge. 😉
I've seen the trailing cursor quite often. It's easily solved by pressing delete once. The pasting has so many problems, including the removal of spaces.
I have quite a few problems since the new system. Tried switching to Edge but that made it no better, so switched back to Firefox.
just ran into the same issue when trying to paste code from SSMS into a reply, except that Edge went "unresponsive" and threw me out of edit mode (losing the entire post). Ended up having to switch to chrome and use a "paste as plain text" option.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
May 29, 2017 at 7:48 am
Something tells me that this is going to take a while...
https://www.sqlservercentral.com/Forums/1878491/SQL-server-2014-is-very-slow
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
May 29, 2017 at 8:02 am
GilaMonster - Monday, May 29, 2017 7:48 AMSomething tells me that this is going to take a while...
https://www.sqlservercentral.com/Forums/1878491/SQL-server-2014-is-very-slow
We'll check back next month ....
May 29, 2017 at 8:05 am
DesNorton - Monday, May 29, 2017 8:02 AMGilaMonster - Monday, May 29, 2017 7:48 AMSomething tells me that this is going to take a while...
https://www.sqlservercentral.com/Forums/1878491/SQL-server-2014-is-very-slowWe'll check back next month ....
So, Thursday?
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
May 29, 2017 at 8:10 am
GilaMonster - Monday, May 29, 2017 8:05 AMDesNorton - Monday, May 29, 2017 8:02 AMGilaMonster - Monday, May 29, 2017 7:48 AMSomething tells me that this is going to take a while...
https://www.sqlservercentral.com/Forums/1878491/SQL-server-2014-is-very-slowWe'll check back next month ....
So, Thursday?
Think the question itself is wrong, should be "SQL Server 2014 DBA is slow"....
😎
May 29, 2017 at 8:16 am
Eirikur Eiriksson - Monday, May 29, 2017 8:10 AMGilaMonster - Monday, May 29, 2017 8:05 AMDesNorton - Monday, May 29, 2017 8:02 AMGilaMonster - Monday, May 29, 2017 7:48 AMSomething tells me that this is going to take a while...
https://www.sqlservercentral.com/Forums/1878491/SQL-server-2014-is-very-slowWe'll check back next month ....
So, Thursday?
Think the question itself is wrong, should be "SQL Server 2014 DBA is slow"....
😎
:w00t:
May 29, 2017 at 8:16 am
GilaMonster - Monday, May 29, 2017 8:05 AMSo, Thursday?
I predict useful information posted on June 31
May 29, 2017 at 8:52 am
Steve Jones - SSC Editor - Monday, May 29, 2017 8:16 AMGilaMonster - Monday, May 29, 2017 8:05 AMSo, Thursday?
I predict useful information posted on June 31
Which year?
😎
May 29, 2017 at 12:08 pm
Eirikur Eiriksson - Monday, May 29, 2017 8:10 AMGilaMonster - Monday, May 29, 2017 8:05 AMDesNorton - Monday, May 29, 2017 8:02 AMGilaMonster - Monday, May 29, 2017 7:48 AMSomething tells me that this is going to take a while...
https://www.sqlservercentral.com/Forums/1878491/SQL-server-2014-is-very-slowWe'll check back next month ....
So, Thursday?
Think the question itself is wrong, should be "SQL Server 2014 DBA is slow"....
😎
The next post will be of the cumulative stats taken an hour after they last ran it. Granted, they didn't save the first query results, so the second will be meaningless. The odds are even if they'll filter for anything with a total over an hour. Oh, and they probably didn't read your article. Maybe the next step is to offer your hourly consulting rate.
May 29, 2017 at 1:18 pm
Oh, and Eirikur...
Brown lamb shanks in a pan, remove from pan
Soften some onion and garlic
Add a good amount of curry powder (I use pre-made, as we get some decent ones here, but you could mix up your own), cook until fragrant
Add tin tomatoes, stock, chopped butternut or pumpkin
Put in oven and cook until lamb is tender. By this point the pumpkin/butternut will have disolved, thickening the stew. If you want chunks of butternut, add most at the start and the rest part-way through the cooking.
Return to stove, add dumplings and cook until the dumplings are ready
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
May 29, 2017 at 1:19 pm
Eirikur Eiriksson - Monday, May 29, 2017 8:52 AMSteve Jones - SSC Editor - Monday, May 29, 2017 8:16 AMGilaMonster - Monday, May 29, 2017 8:05 AMSo, Thursday?
I predict useful information posted on June 31
Which year?
😎
Since June doesn't have 31 days, any year.
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
Viewing 15 posts - 58,741 through 58,755 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply