Viewing 15 posts - 1 through 15 (of 34 total)
I was shocked to learn that this table still exists in SQL Server, and nobody is talking about it ^^.
It seems to be around since the 80s as it is...
April 2, 2023 at 10:47 am
Thank you, that reminds me of the tricks for being able to view youtube videos in your country you're not supposed to, it's so long ago I had time for...
July 29, 2017 at 4:09 pm
I remember having a lot of problems when the default collation changed from 2005 to 2008.
Many of them were solved by using COLLATE DATABASE_DEFAULT. Just a hint, not more 😉
March 31, 2015 at 7:34 am
--oops, I overlooked the second page of post, sorry
December 13, 2013 at 5:45 am
Thank you Dwain,
yep, I hoped someone could explain the implicit conversion rules...
December 11, 2013 at 2:33 am
.... and the ORDER BY 1 means ORDER BY the first column expression the SELECT Statement.
Just adding this because I didn't know that not a long while ago...
June 18, 2013 at 2:48 am
Hi Petr,
that worked for me, too, thx.
... after I closed the excel file that is... 🙂
May 31, 2013 at 8:16 am
It's February 2013 and there are still no courses out for 2012 on Self Test Software.
It's a pity, because they were really good for preparing for 40-433 and 40-451.
February 15, 2013 at 1:55 am
Hi Steve,
thanks a lot for your work!
One tiny addition: You could update the link list here http://www.sqlservercentral.com/articles/Build+List/71065/.
Afterwards it shouldn't change for the next two years I guess.
December 17, 2012 at 2:31 am
Hmm, maybe that was a misunderstanding: I want to reduce the time it takes to see the History Log of the Maintenance Plan, has nothing to do with backups or...
December 14, 2012 at 5:07 am
Thank you for the fast reply,
no, I didn't, because I don't want to touch the history, if it is possible.
I know, it sounds like wanting to eat the cake and...
December 14, 2012 at 2:35 am
I am sorry,
I trusted Pinal Dave on this one, without crosschecking MS:
http://blog.sqlauthority.com/2011/02/15/sql-server-lck_m_xxx-wait-type-day-15-of-28/
who wrote
"LCK_M_SCH_S - Occurs when a task is waiting to acquire a Schema Share lock."
an...
November 22, 2012 at 7:34 am
I am also delighted, thanks a lot!
here a little correction
'LOCK - Waiting to acquire a Schema Modify lock' WHERE dbo.[#results].[wait_type] = 'LCK_M_SCH_S'
... should be Share.
November 22, 2012 at 6:59 am
Hi there,
BULK INSERT works fine, see the details here: http://msdn.microsoft.com/en-us/library/ms188365.aspx
To split the strings, you can help yourself with a temporary table.
What confused me as a newbie was the file path:
"
data_file...
November 15, 2012 at 1:49 pm
Thank you all for your response,
I still like paper-based media, but maybe I am also too old-fashioned.
sqlmag is good, but covers only SQL Server, the best site I found so...
November 14, 2012 at 1:55 am
Viewing 15 posts - 1 through 15 (of 34 total)