Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,711 through 31,725 (of 59,099 total)

RE: Comapre records using cursor

ashisht4u (12/12/2011)
Lynn,
Actually I'm preparing for my interview and I came across some of the question on DB, I'm at C++ but not done much work on SQL-Server. I want to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 12, 2011 at 9:50 pm

#1420344
RE: SELECT statement - value gets truncated when selecting from XML column

MidBar (12/12/2011)
NO. varchar(max) and Nvarchar(max) are giving the same results.
if XML allow 2GB data then why its stopping at some specific number of characters.
This must be some limitation in settings.
Does...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 12, 2011 at 9:45 pm

#1420343
RE: find table relationships

PHXHoward (12/12/2011)
Hi,
Is it possible to take two tables and see how they are connected?
I have an application name listed in one table and a support group listed in another table...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 12, 2011 at 9:32 pm

#1420341
RE: DataBase Enging Tuning

Option 4... provided that it ISN'T a production server, learn from your mistakes... let DTA rip and discover the problems it causes. "A Developer must not guess... a Developer...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 12, 2011 at 9:24 pm

#1420338
RE: Trigger to insert records on a linked server else in a local server

ALZDBA (12/11/2011)
[sarcasm]
As a firefighter sysadmin/dba, I cannot but embrace your choice of solution.
( insert in table a server a with a trigger to insert into serverb some table)
This will guarantee...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 12, 2011 at 6:03 am

#1419997
RE: tempdb file placement

Dev (12/12/2011)
per BOL:
If data must be quickly recoverable, consider mirroring the transaction log and putting the database on a RAID 5 disk. RAID 5 provides redundancy of all...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 12, 2011 at 5:56 am

#1419990
RE: Convert Time Stamp in Query

Bron Tamulis (12/12/2011)
Thanks everyone for response.
For the record both of these queries worked and returned exact same results:
select * from Orders where cast(orderdate as date) = '2011-11-30'
select *
from dbo.Orders
where...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 12, 2011 at 5:53 am

#1419987
RE: #table OWNER

chauchs (12/9/2011)
I want to shrink tempdb but I have a message
DBCC SHRINKFILE: Page 1:378832 could not be moved because it is a work table page.
.I cant restart the instance.
I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 12, 2011 at 5:47 am

#1419980
RE: Modulo operator problem

Elliott Berkihiser (12/7/2011)
OK, this looks like as good time as any to ask about DateTime data. The advice to the OP was to use datetime datatypes for date data....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 12, 2011 at 5:28 am

#1419971
RE: create ipaddress table

stebennettsjb (12/12/2011)
Hi all,
trying to learn a tsql dev stuff so decided to look at changing our ip document from a word file to a database.
How do you prefer...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 12, 2011 at 5:23 am

#1419969
RE: Split the values from ('1,2,3,4') to ('1','2','3','4') or (1,2,3,4)

panneermca35 (12/12/2011)
so how i can split the @str value from ('1,2,3,4') to ('1','2','3','4') or (1,2,3,4)[/b]
Help me please.
thank you.
Please see the following article.
http://www.sqlservercentral.com/articles/Tally+Table/72993/
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 12, 2011 at 5:20 am

#1419968
RE: Split the values from ('1,2,3,4') to ('1','2','3','4') or (1,2,3,4)

Cadavre (12/12/2011)
DECLARE @str NVARCHAR(MAX) = '1,2,3,4' SET @str = '''' + REPLACE(@str,',',''',''') + '''' SELECT * FROM emp
WHERE empid IN (@str)
That'll only work if you use dynamic SQL or maybe if you use...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 12, 2011 at 5:18 am

#1419965
RE: Split the values from ('1,2,3,4') to ('1','2','3','4') or (1,2,3,4)

RowanCollum (12/12/2011)
In SS2005, the following may be another possibility:
select * from emp where empid in
( select i.value('text()[1]','int')
from (select cast('<i>'+replace(@str,',','</i><i>')+'</i>' as xml) as xlist) s
cross apply s.xlist.nodes('/i')...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 12, 2011 at 5:11 am

#1419962
RE: Wjat would be a good supplmental skill to SQL server

Heh... didn't mean to turn it into a "me" post. I actually know quite a few folks that make more than their bosses.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 11, 2011 at 12:40 pm

#1419826
RE: Trigger to insert records on a linked server else in a local server

I've never found a decent use for it before but this sounds like the perfect use for an "INSTEAD OF" trigger against a view. It would guarantee that any...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 11, 2011 at 9:36 am

#1419819

Viewing 15 posts - 31,711 through 31,725 (of 59,099 total)