| Author |
 Topic  |
|
Kristen
Test
United Kingdom
22191 Posts |
 Posted - 01/18/2010 : 03:54:52
|
Interesting ... no Twit posts since Oct-2009, when Graz opens the Ask.SQLTeam bar in this hotel  |
 |
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 01/18/2010 : 06:21:59
|
Maybe they're hibernating for the winter. Alternitively, it could be because it is harder to get into a full blown trolling session on Ask.SQLTeam.
Please don't wake them up. |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 01/22/2010 : 03:48:48
|
| I'm giving up on DBA 007 - every post a corrupt database, rarely any come-back when asked for more info. What is he doing? Fixing them? (then he should know how to interpret DBCC CHECKDB output) or is he surrounded by corrupted DBs? (I've no answer to that ... except to try to find out what company and avoid their products) |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 01/22/2010 : 04:02:49
|
I reckon no hope here either:
http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=39000
I said:
"If you really must format it in SQL then use:
CONVERT(varchar(99), MyDateColumn, 999)
see SQL Server documentation for CONVERT for the correct values for the "999" parameter, and the correct size for varchar(99)"
user's next question:
"however I used (convert(varchar(99),'Feb 25 2003 12:00:00:444PM',999)) to insert into datetime col hope it is not a problem ...correct me."
and, no, I don't think the O/P is talking generically because they offered this code example 
create table a (a datetime)
insert into a values (convert(varchar(99),'Feb 25 2003 12:00:00:444PM',999))
insert into a values (convert(datetime,'Feb 25 2003 12:00:00:444PM',999))
which, strangely enough, works (I didn't think you could put an expression in a VALUES list but Ho!Hum!) |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
|
|
russell
Pyro-ma-ni-yak
USA
5037 Posts |
Posted - 01/23/2010 : 16:45:52
|
| too funny. i bet it's the windows swap file filling the disk as ssms caused it to start paging out memory. |
Edited by - russell on 01/23/2010 16:46:23 |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 01/24/2010 : 03:18:14
|
Management studio uses a temp file for large resultsets. It's stored somewhere on the C drive and that location can't be changed.
I've run into this before though, in my case, it was mostly because I was low on space on the C drive and hadn't noticed.
--
Gail Shaw
SQL Server MVP |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 01/27/2010 : 12:08:55
|
quote:
try using schema names for tables as well as view like
create view schemaname.DERPosi with schemabinding
as
select TID,SeatN,Posi,recGrp from schemaname.DERPosi_201001
union all
select TID,SeatN,Posi,recGrp from schemaname.DERPosi_201002
union all
select TID,SeatN,Posi,recGrp from schemaname.DERPosi_201003;
It return erros as follow,
Invalid object name 'schemaname.DERPosi_201001'.
Would you Adam and Eve it?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138936#542785 |
Edited by - Kristen on 01/27/2010 12:09:50 |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 01/29/2010 : 04:56:56
|
3 table Cartesian join - although the saving grace is that only two tables will return results because it also has
FROM MyTable AS A
WHERE A.ID NOT IN (SELECT A.ID FROM SomeOtherTable)
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139058
at least I *think* that's what its doing! |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 02/03/2010 : 14:05:23
|
quote:
Originally posted by Kristen
I'm giving up on DBA 007 - every post a corrupt database, rarely any come-back when asked for more info.
He's back, with what looks like another corruption problem.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139311
--
Gail Shaw
SQL Server MVP |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 02/08/2010 : 02:36:48
|
Is it me?
Me: "WHERE ZipData = @Zipcode' + Convert(varchar(30),@Zipcode) ..."
Them;
I am getting error when i try to execute this statment
Set @CondStmt1 = 'SELECT @ex = COUNT(1) from ' + @TblName + ' WHERE ZipData = @Zipcode' + Convert(varchar(30),@Zipcode)EXEC sp_executesql @CondStmt1, N'@ex INT OUTPUT, @Zipcode INT', @existsZip OUTPUT, @Zipcode
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@Zipcode85260".
Me: "Did you delete the bit in Blue?"
Them: "i didn't delte the blue one from your suggestion. bcz i am getting some syntax error"
Yeah, well you would, wouldn't you?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139275#544801
|
|
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 02/08/2010 : 06:51:11
|
| Lost cause? |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 02/08/2010 : 06:54:55
|
| Fired cause I reckon. O/P by his boss, by the looks of it! |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 02/08/2010 : 06:57:47
|
But here's a lost cause:
Visakh: "SELECT * FROM sys.triggers WHERE parent_class=0 will list out all the DDL triggers in your db"
O/P: "I used this query.. select * from sysobjects where xtype='TR' but my DDL trigger is not listing in this"
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139483#545575 |
|
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 02/08/2010 : 07:32:01
|
I can see its going to be a good week..  |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48076 Posts |
Posted - 02/08/2010 : 08:59:40
|
quote:
Originally posted by Kristen
But here's a lost cause:
Visakh: "SELECT * FROM sys.triggers WHERE parent_class=0 will list out all the DDL triggers in your db"
O/P: "I used this query.. select * from sysobjects where xtype='TR' but my DDL trigger is not listing in this"
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139483#545575
I liked this question also
Can you please teach me how to get max usage from BOL ? |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 02/08/2010 : 09:37:20
|
I have a copy under the pillow that I sleep on at night ...  |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 02/19/2010 : 12:08:46
|
"I'm giving up on DBA 007 - every post a corrupt database, rarely any come-back when asked for more info. What is he doing? Fixing them? (then he should know how to interpret DBCC CHECKDB output) or is he surrounded by corrupted DBs? (I've no answer to that ... except to try to find out what company and avoid their products)"
Update: I find it staggering, almost every day more errors from maintenance plans, we rarely identify the cause (maybe someone somewhere else does) and still it goes on ... goodness knows what state the servers / data are in, and I really REALLY hope that this is not some outsourced unit that some company I deal with is using ...
http://www.sqlteam.com/forums/search.asp?mode=DoIt&MEMBER_ID=44217 |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 02/19/2010 : 18:08:51
|
He posts over at SSC as well http://www.sqlservercentral.com/Forums/UserInfo727627.aspx
Part of me hopes that he is outsourced resource for a company I deal with, as if that is the case there's a good chance I'll get called in to fix stuff up.
--
Gail Shaw
SQL Server MVP |
Edited by - GilaMonster on 02/19/2010 18:11:30 |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 02/20/2010 : 01:50:24
|
Would be better to bring it back in-house. I can't believe there isn't some major data loss waiting just around the corner; whatever the outfit there must be a need for some expert help to sort out this mess, and if they aren't adopting that "they are all doomed".
Expecting free help on this scale, with so little response, is not a reasonable tactical approach for this (or any) company. I personally can't get any personal enjoyment out of helping further. I'm out ... |
|
|
|
Topic |
|
Twit List
