Sean Lange

Forum Replies Created

Viewing 15 posts - 4,651 through 4,665 (of 15,374 total)

RE: Today's Random Word!

Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
whereisSQL? (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
Ed Wagner (6/2/2014)
SQLRNNR (6/1/2014)
dickory
Dock
Mouse
Keyboard
Tray
System
Malfunction
Blue Screen
Death
Creeping
Lightning
Bell
Fade
Master (I guess if I...
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

June 2, 2014 at 8:37 am

#1718231
RE: Today's Random Word!

Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
whereisSQL? (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
Ed Wagner (6/2/2014)
SQLRNNR (6/1/2014)
dickory
Dock
Mouse
Keyboard
Tray
System
Malfunction
Blue Screen
Death
Creeping
Lightning
Bell
Fade
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

June 2, 2014 at 8:31 am

#1718226
RE: Are the posted questions getting worse?

Did the "Recent Posts" link get moved? I don't see it any more all of a sudden.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

June 2, 2014 at 8:19 am

#1718221
RE: Today's Random Word!

Ed Wagner (6/2/2014)
crookj (6/2/2014)
whereisSQL? (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
Ed Wagner (6/2/2014)
SQLRNNR (6/1/2014)
dickory
Dock
Mouse
Keyboard
Tray
System
Malfunction
Blue Screen
Death
Creeping
Lightning
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

June 2, 2014 at 8:09 am

#1718219
RE: DB concurrency how to....

vinpes (6/2/2014)
Hi SSChampion,
you are right, indeed my problem with my strategy is in case of same rollback.
I am storing pointer to nextrows
SET @nextNumReg = (SELECT [RelNumReg] + 1.....
cause I need...
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

June 2, 2014 at 8:03 am

#1718217
RE: Cluster index fragementation

Why varchar(1)? You do realize that is literally three times the storage for each row? 1 byte to hold the value plus the 2 bytes of overhead for varying length.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

June 2, 2014 at 7:49 am

#1718210
RE: DB concurrency how to....

vinpes (6/1/2014)
Hello guy,
Yes, i have evaluated to work with sequence, but there are some limitation , ie. Sequence numbers inserted into a table can have gaps when a transaction is...
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

June 2, 2014 at 7:42 am

#1718201
RE: Today's Random Word!

Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
Ed Wagner (6/2/2014)
SQLRNNR (6/1/2014)
dickory
Dock
Mouse
Keyboard
Tray
System
Malfunction
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

June 2, 2014 at 7:21 am

#1718191
RE: Today's Random Word!

Ed Wagner (6/2/2014)
crookj (6/2/2014)
Ed Wagner (6/2/2014)
SQLRNNR (6/1/2014)
dickory
Dock
Mouse
Keyboard
Tray
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

June 2, 2014 at 7:14 am

#1718188
RE: Today's Random Word!

crookj (5/30/2014)
Sean Lange (5/30/2014)
Revenant (5/30/2014)
Ed Wagner (5/30/2014)
crookj (5/30/2014)
Sean Lange (5/30/2014)
Ed Wagner (5/30/2014)
Sean Lange (5/30/2014)
Ed Wagner (5/30/2014)
Sean Lange (5/30/2014)
SQLRNNR (5/30/2014)
Potato
fingerling
Olive Oil
Rosemary
Thyme
Parsley
Scarborough (Faire )
Simon
Silence [Sounds of]
Bridge
over
under
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

May 30, 2014 at 3:04 pm

#1717966
RE: UNION and INSERT

sqldriver (5/30/2014)
Sean Lange (5/30/2014)
sqldriver (5/30/2014)
I take no responsibility for repeatedly calling a function on an insert or using ISNUMERIC on a function like it's my birthday.
LOL. Yes that is particularly...
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

May 30, 2014 at 3:04 pm

#1717965
RE: UNION and INSERT

sqldriver (5/30/2014)
I take no responsibility for repeatedly calling a function on an insert or using ISNUMERIC on a function like it's my birthday.
LOL. Yes that is particularly horrible. I have...
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

May 30, 2014 at 2:32 pm

#1717959
RE: UNION and INSERT

sqldriver (5/30/2014)
Hi,
Just came across some weird legacy code in my system where an INSERT is followed by three UNIONs of the exact same query. What's the purpose of that? Deduplication...
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

May 30, 2014 at 2:19 pm

#1717956
RE: Get Data Centralized

sultan.shaikh (5/30/2014)
Hi, I am not sure how to tackle the following. Environment has SQL Server 2005 and above which hosts one database (table1 & table2) per server. I have created...
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

May 30, 2014 at 1:52 pm

#1717939
RE: CTE - why use, and NOLOCK

Michael_Garrison (5/30/2014)
2. Yes, I know by now NOLOCK is bad. (I have seen all you guys say that, the top people in these forums, you know who you...
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

May 30, 2014 at 12:32 pm

#1717920

Viewing 15 posts - 4,651 through 4,665 (of 15,374 total)