SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Twit List
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 88

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/18/2010 :  03:54:52  Show Profile  Reply with Quote
Interesting ... no Twit posts since Oct-2009, when Graz opens the Ask.SQLTeam bar in this hotel
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 01/18/2010 :  06:21:59  Show Profile  Reply with Quote
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.
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/22/2010 :  03:48:48  Show Profile  Reply with Quote
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)
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/22/2010 :  04:02:49  Show Profile  Reply with Quote
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!)
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/23/2010 :  07:20:16  Show Profile  Reply with Quote
Why do I get a disk full message when I try view 68,000,000 rows in the Console?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138753
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 01/23/2010 :  16:45:52  Show Profile  Visit russell's Homepage  Reply with Quote
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
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/24/2010 :  03:18:14  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/27/2010 :  12:08:55  Show Profile  Reply with Quote
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
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/29/2010 :  04:56:56  Show Profile  Reply with Quote
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!
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 02/03/2010 :  14:05:23  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/08/2010 :  02:36:48  Show Profile  Reply with Quote
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


Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 02/08/2010 :  06:51:11  Show Profile  Reply with Quote
Lost cause?
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/08/2010 :  06:54:55  Show Profile  Reply with Quote
Fired cause I reckon. O/P by his boss, by the looks of it!
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/08/2010 :  06:57:47  Show Profile  Reply with Quote
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
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 02/08/2010 :  07:32:01  Show Profile  Reply with Quote
I can see its going to be a good week..
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 02/08/2010 :  08:59:40  Show Profile  Reply with Quote
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 ?
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/08/2010 :  09:37:20  Show Profile  Reply with Quote
I have a copy under the pillow that I sleep on at night ...
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/19/2010 :  12:08:46  Show Profile  Reply with Quote
"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
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 02/19/2010 :  18:08:51  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/20/2010 :  01:50:24  Show Profile  Reply with Quote
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 ...
Go to Top of Page
Page: of 88 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000