Forum Replies Created
Viewing 15 posts - 5,536 through 5,550 (of 59,089 total)
-
Reply To: Redesign of old Table
ScottPletcher wrote:Jeff Moden wrote:ScottPletcher wrote:And, using triggers, you can make the COMPRESSion and DECOMPRESSion transparent to the developers
Interesting... How do you make DECOMPRESSion transparent to SELECTs (for example) using...
--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) -
Reply To: SQL Sever becoming Non Responsive
IT researcher wrote:In a scenario, where 100 users over LAN open data entry application and edit values(in a grid) from 9 AM to 9 PM, wouldn't there be a speed issue,...
--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) -
Reply To: SQL Sever becoming Non Responsive
If that box has 12,000 connections, you may have some software running against it or a stored procedure running that has "Connection Leaks". You should probably investigate what is making...
--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) -
Reply To: Redesign of old Table
ScottPletcher wrote:And, using triggers, you can make the COMPRESSion and DECOMPRESSion transparent to the developers
Interesting... How do you make DECOMPRESSion transparent to SELECTs (for example) using triggers?
--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) -
Reply To: How to delete child records from table tradecode that not have parent on tradeco
movieboxproappapk wrote:Useful information
I can feel the spam getting ready to flow on this one... 😉
--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) -
Reply To:
I don't necessarily agree with it but, once each month, we do both Windows Updates and CU updates to our Dev boxes. If nothing goes haywire, we update our UAT/Staging...
--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) -
Reply To: A varchar(MAX) STRING_SPLIT function for SQL 2012 and above
Kristen-173977 wrote:Jonathan AC Roberts wrote:Or you could just add a WHERE clause to filter them out as it's a table valued function.
Yes ... but my Splitter returns an Item No, and if...
--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) -
Reply To: A varchar(MAX) STRING_SPLIT function for SQL 2012 and above
Now that's a matter of opinion. I, for one, want it to return empty or null strings for any element that exists but isn't filled. One of the things 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) -
Reply To: Newb - SQL Server IIF() Function
Jeffrey Williams wrote:Jeff Moden wrote:Shifting gears a bit but on a similar subject... the PIVOT operator in MS Access is totally awesome. I do NOT understand why MS made such a crippled...
--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) -
Reply To: Newb - SQL Server IIF() Function
Shifting gears a bit but on a similar subject... the PIVOT operator in MS Access is totally awesome. I do NOT understand why MS made such a crippled version 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) -
Reply To: poor query performance by joining large table and new CE
As almost a sidebar, try a couple of things on your original query (posted below just so you don't have to look back.... they've worked for me in the past.
insert...
--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) -
Reply To: Name of the remote server in a query
Ram wrote:My thanks to Jeff, Voldemar and Scott.
@jeff, I was thinking of getting the remote server name through some variable or a function in remote server while I missed 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) -
Reply To: Newb - SQL Server IIF() Function
Kristen-173977 wrote:Sorry, I have explained that badly. It definitely isn't a bug in SQL, but it can cause a bug in my software (if I change from ISNULL to COALESCE...
--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) -
Reply To: Newb - SQL Server IIF() Function
Kristen-173977 wrote:ScottPletcher wrote:From what I've read, at least, the STRING_AGG performs well.
First result I found in Google :
Exactly... and it's easy to use and it doesn't have 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) -
Reply To: Newb - SQL Server IIF() Function
ScottPletcher wrote:I admit, I don't expect IIF to go away (ever), as bad an idea as it was to corrupt T-SQL with it. I'm just hoping they don't bring over...
--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 - 5,536 through 5,550 (of 59,089 total)