June 24, 2013 at 2:24 pm
Just so the rest of you can feel jealous, I got a hug from Gail and a handshake from Rodney last week 🙂
June 24, 2013 at 3:44 pm
GilaMonster (6/24/2013)
You shrunk a database? How could you???:hehe:
Yeah, they told me at PASS that every time you shrink a database a puppy gets killed. :crying:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 24, 2013 at 4:01 pm
Steve Jones - SSC Editor (6/24/2013)
Just so the rest of you can feel jealous, I got a hug from Gail and a handshake from Rodney last week 🙂
I can't top that recently but I still have the piece of rebar that Rodney presented to me back in 2011.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 24, 2013 at 4:03 pm
The Dixie Flatline (6/24/2013)
GilaMonster (6/24/2013)
You shrunk a database? How could you???:hehe:
Yeah, they told me at PASS that every time you shrink a database a puppy gets killed. :crying:
You sure? I was told it would kill a project manager that thought they could design databases... been shrinkin' databases ever since. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
June 24, 2013 at 7:38 pm
Jeff Moden (6/24/2013)
The Dixie Flatline (6/24/2013)
GilaMonster (6/24/2013)
You shrunk a database? How could you???:hehe:
Yeah, they told me at PASS that every time you shrink a database a puppy gets killed. :crying:
You sure? I was told it would kill a project manager that thought they could design databases... been shrinkin' databases ever since. 😀
SOM
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 25, 2013 at 5:21 am
GilaMonster (6/24/2013)
You shrunk a database? How could you???:hehe:
Uhh, with this:
DBCC SHRINKFILE('WBT', 150000)
😉
(Yes, I know everyone is kidding around, and it's not something I intend to do regularly...):-D
June 25, 2013 at 5:47 am
jasona.work (6/25/2013)
GilaMonster (6/24/2013)
You shrunk a database? How could you???:hehe:
Uhh, with this:
DBCC SHRINKFILE('WBT', 150000)😉
Blasphemy. Sheer Blasphemy.
Someone take away his golden SysAdmin key. Expel him from the ranks of the SQL Conspiracy forthwith! Revoke his TitD pass and remand him to the hippo's care!
June 25, 2013 at 6:45 am
Brandie Tarvin (6/25/2013)
jasona.work (6/25/2013)
GilaMonster (6/24/2013)
You shrunk a database? How could you???:hehe:
Uhh, with this:
DBCC SHRINKFILE('WBT', 150000)😉
Blasphemy. Sheer Blasphemy.
Someone take away his golden SysAdmin key. Expel him from the ranks of the SQL Conspiracy forthwith! Revoke his TitD pass and remand him to the hippo's care!
Could be worse.
HOW could it POSSIBLY be worse!?!
Could be raining...
/thunder, followed by driving rain...
Or I could have this set up as a regularly scheduled Agent job...
:hehe:
June 25, 2013 at 7:32 am
jasona.work (6/25/2013)
GilaMonster (6/24/2013)
You shrunk a database? How could you???:hehe:
Uhh, with this:
DBCC SHRINKFILE('WBT', 150000)😉
(Yes, I know everyone is kidding around, and it's not something I intend to do regularly...):-D
Umm... don't you mean:
DBCC SHRINKFILE('WTF', 150000)
:w00t::w00t::w00t:
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 25, 2013 at 7:47 am
Strange as it may seem in this day and age of cheap HD space, there are still places that refuse to provide enough space for their data forcing desperate people to use DBCC SHRINKFILE
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
June 25, 2013 at 7:58 am
Revenant (6/24/2013)
Better database than kids.
:w00t:
June 25, 2013 at 8:21 am
Stefan Krzywicki (6/25/2013)
Strange as it may seem in this day and age of cheap HD space, there are still places that refuse to provide enough space for their data forcing desperate people to use DBCC SHRINKFILE
Yes, our SAN admins still look at me like I'm mad when I ask for 100GB of extra storage on their £200k+ SAN. Attitudes to data seem to be stuck in the past and I think a lot of people are getting caught out by the recent explosion in data.
I use exponential curves to forecast disk usage on data warehouses now as there's no business appetite to (ever) archive data and new data sources pop up all the time. I'd rather have one argument about why we need to buy and reserve 30TB of database storage in the next 3 years than a hundred about the odd 100GB here and there.
Btw, was great to meet Grant and Steve last Friday. I must make an effort to attend more events! Unfortunately, there was problem at work and I had to bail before lunch, so missed out on seeing Gail (and a free beer!).
June 25, 2013 at 10:23 am
HowardW (6/25/2013)
Stefan Krzywicki (6/25/2013)
Strange as it may seem in this day and age of cheap HD space, there are still places that refuse to provide enough space for their data forcing desperate people to use DBCC SHRINKFILEYes, our SAN admins still look at me like I'm mad when I ask for 100GB of extra storage on their £200k+ SAN. Attitudes to data seem to be stuck in the past and I think a lot of people are getting caught out by the recent explosion in data.
I use exponential curves to forecast disk usage on data warehouses now as there's no business appetite to (ever) archive data and new data sources pop up all the time. I'd rather have one argument about why we need to buy and reserve 30TB of database storage in the next 3 years than a hundred about the odd 100GB here and there.
Btw, was great to meet Grant and Steve last Friday. I must make an effort to attend more events! Unfortunately, there was problem at work and I had to bail before lunch, so missed out on seeing Gail (and a free beer!).
You'd think disk space came directly out of some SAN Admins paycheck.
And the many discussions about having enough free space to recover the main warehouse.
Thousands of $'s wasted in time and workarounds vs. doing it right.
Especially important when the data center went remote.
It's not like you can just plug something in to work with temporarily.
June 25, 2013 at 1:48 pm
Jan Van der Eecken (6/14/2013)
dwain.c (6/13/2013)
Sean Lange (6/13/2013)
WayneS (6/13/2013)
dwain.c (6/12/2013)
I can only imagine what it must be like to have SQL Server running in some non-English language. MS probably translated the obtuse into the indecipherable.Maybe the error messages are perfect in other languages, and it's only when in English that they become so obtuse.
That makes a lot of sense. It does seem like some of the error messages where written in Swahili first and then translated to English by a non-native speaker. 🙂
More likely the base language is Klingon.
BTW, Sean, it is called kiSwahili. You'd come across as quite rude if you call it Swahili. Just had to mention it in case you ever make it to Kenya or Tanzania.
That's somewhat amazing, on two counts. First, I've never seen Kiswahili written with a small k and capital S before. Second, those Swahili speakers must be extremely reasy to take offense - ready, in fact, to an extend which I simply do not believe.
When was the last occassion on which, when speaking (or writing) English, you said (or wrote) Gaeilge instead or Irish or Gàidhlig instead of Gaelic or Gaelk instead of Manx or Français instead of French or castellano instead of Spanish or galego instead of Galician or Deutsch instead of German or used any language's name for itself instead of its name in the language you were speaking? On all the occassions when you referred to one of those languages (or any other language) by its non-native name were you being offensive? When an Italian says "Io non parlo inglese" instead of "Io non parlo English" is he being offensive?
I realise that roots in Bantu languages are almost never used in those languages without prefixes, but it is normal practise in English (and in most other European languages) when naming the most common Bantu languages to use the root on its own as the name of the language (of course in those Bantu languages where the gender/class of nouns denoting languages is indicated by a zero prefix the speakers of those languages do the same) ; so for example we say Ganda and Swahili and Tswana and Sotho and Xhoso and Zulu, not Oluganda, Kiswahili, Setswana, Sesotho, Isixhosa, and Isizulu. In the case of most of these languages, there is a certainty of confusion if the root is used on its own when speaking in the language, since many other words are formed from the root using different prefixes (for example words for a country, for a person or people of that country, and so on, but of course we get round that by not using the root alone for those other meanings (eg we use Botswana for the country, which is the Tswana word; and use nouns/adjectives formed by normal English rules for the cases where we don't just add the appropriate Tswana prefix - although I've heard motswana and batswana used in English for Botswanan person and Botswanan people; Similarly Uganda for the country, Buganda for the region where Ganda is the dominant language, and so on).
Is there any reason for Swahili speakers to be really hung up on wanting that prefix "ki" to be used when referring to the language in English? If there is, would that give us Gaels an excuse to insist that all English speakers learn to pronounce (and of course spell) the language names "Gàidhlig na h-Alba", "Gaeilge", "Gaoluinn Mumhain", and "Gaelk Vannin" since those four names are the names we use in our three languages for those three languages? How much fun should we all have with languages whose names include sounds which don't occurr in English, and languages that distinguish two sounds that appear to English-trained ears to be the same and use both those sounds in their name for the language?
Tom
June 25, 2013 at 2:21 pm
No idea about Swahili, since it's not native to my neck of the world, but Zulu is correctly written as isiZulu when writing in the language, not Isizulu. It's similar for most proper nouns in that language. Xhosa's the same.
For example
Nkosi sikelel' iAfrika
(Xhosa)
Thina, bantu baseNingizimu Afrika
(Zulu)
Sotho on the other hand has the first letter capitalised, I've never seen otherwise.
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 - 40,351 through 40,365 (of 66,688 total)
You must be logged in to reply to this topic. Login to reply