Forum Replies Created
Viewing 15 posts - 58,636 through 58,650 (of 59,067 total)
-
RE: Want Sql Query
Vishal,
If your field list looks like this...
field value: Oracle,VB,ASP,PHP
field value: Java,VB,PHP,MYSql
field value: Java,VB,Oracle,Asp.net,MSSQL,Asp
field value: Windows,HASP,Excel,VBA
Consider the following code to keep from listing the 4rh line when looking for ASP and...
--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) -
RE: Select table from another Database
And, you might want to consider using the user name in the 3 part naming convention as part of best practices...
--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) -
RE: Without dynamic SQL, Top X Query
With 7 million rows of data, I'm thinking that you'll get a recompile on run anyway just due to the number of changes in the data. So, I gotta ask,...
--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) -
RE: Help with SQL Server 2005 Isolation Hint Info
Chris,
Likewise it's interesting to think that databases are not used for performance... whatever. The real key is that the inclusion of the NOLOCKs greatly reduced the number of deadlocks in...
--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) -
RE: Help with SQL Server 2005 Isolation Hint Info
Chris,
Yup... I agree on the data integrity thing but considering that a ROLLBACK is supposed to be (and, fortunately, is) an extremely rare occurance (and then usually only on the...
--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) -
RE: Help with SQL Server 2005 Isolation Hint Info
>I can only say that I would not do that.
Why not, Chris?
--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) -
RE: Help with SQL Server 2005 Isolation Hint Info
Thanks for the reply, Chris. Your experience seems to contradict what BOL says. Now, THAT's never happened before, eh?
Kinda why I asked if anyone had experience with...--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) -
RE: Storing credit card information
Rumor has it that there are some very stiff penalties for storing unencrypted credit card information and other seemingly minor infractions on safeguards. I would say there's no such thing...
--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) -
RE: Query taking too long
Just for grins, how fast does it run without the ORDER BY? If it's really fast, use the 14 row result set as a derived table and select from THAT...
--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) -
RE: BCP and encrypted password
Just a quick thought... why does the BCP login/password need rights to anything but the destination table? Make a user that only has rights to the input staging table (you...
--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) -
RE: Working with time in T-SQL
This will convert the number of seconds since midnight to a datetime (for today) datatype so you can do the join...
SELECT DATEADD(ss,secondssincemidnightcol,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0))
--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) -
RE: Enterprise Manager Tricks
Nice job Sushila.... I use EM to troubleshoot other people's more complex joins and, occasionally, to make my own. And, I "steal" code from it and QA quite a bit...
--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) -
RE: How to get comma delimeted value seperated in join select statement
The "best" way would be to not store data in such a fashion...
That, not-with-standing... something like this should work...
SELECT c.CategoryName,
c.CategoryID
FROM Category c,
UserCategory uc
WHERE ','+uc.CategoryID+',' LIKE...
--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) -
RE: Federated Databases In Data Warehousing
Admittedly, I've not done much with Federated Servers but I'm not sure why the relatively simple process of ETL would justify the need even in a world wide setting. The...
--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) -
RE: are Synonyms possible in MS SQL SERVER 2000
For reads, a "surrogate view" will give you that transparency. The view would just do a SELECT * from the 4 part name. (Just gotta be careful that you're not...
--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)
Viewing 15 posts - 58,636 through 58,650 (of 59,067 total)