April 10, 2015 at 12:22 pm
Luis Cazares (4/10/2015)
Grant Fritchey (4/10/2015)
Brandie Tarvin (4/10/2015)
Grant Fritchey (4/10/2015)
Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.
Are you saying I'm on drugs?
Was that supposed to be a secret? :w00t:
Look, Grant, there's a reason you didn't get the circus job. We just didn't want to break the news to you.
April 10, 2015 at 12:24 pm
Luis Cazares (4/10/2015)
Grant Fritchey (4/10/2015)
Brandie Tarvin (4/10/2015)
Grant Fritchey (4/10/2015)
Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.
Are you saying I'm on drugs?
Was that supposed to be a secret? :w00t:
I just got a .NET error screen when I clicked the link in the new post email. It was repeatable for about a minute and I couldn't go to the forums home either. It didn't give anything away.
As for being on drugs...I think that's a separate question and certainly not my business. 😛
April 10, 2015 at 12:26 pm
Brandie Tarvin (4/10/2015)
Grant Fritchey (4/10/2015)
Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.
I might have been that high once but I have plausible deniability because I can barely remember college.
_______________________________________________________________
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/
April 10, 2015 at 12:33 pm
Brandie Tarvin (4/10/2015)
Luis Cazares (4/10/2015)
Grant Fritchey (4/10/2015)
Brandie Tarvin (4/10/2015)
Grant Fritchey (4/10/2015)
Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.
Are you saying I'm on drugs?
Was that supposed to be a secret? :w00t:
Look, Grant, there's a reason you didn't get the circus job. We just didn't want to break the news to you.
<squeak>really?</squeak>
And I showered and everything.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 10, 2015 at 12:35 pm
Grant Fritchey (4/10/2015)
Brandie Tarvin (4/10/2015)
Grant Fritchey (4/10/2015)
Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.
Are you saying I'm on drugs?
What ever you're on, I want two of those:-D
😎
April 10, 2015 at 12:39 pm
Brandie Tarvin (4/10/2015)
Grant Fritchey (4/10/2015)
Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.
What are you using for the SFTP?
😎
April 10, 2015 at 12:53 pm
Eirikur Eiriksson (4/10/2015)
Brandie Tarvin (4/10/2015)
Grant Fritchey (4/10/2015)
Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.
What are you using for the SFTP?
😎
Ah, well, that's the issue.
April 10, 2015 at 12:58 pm
Brandie Tarvin (4/10/2015)
Eirikur Eiriksson (4/10/2015)
What are you using for the SFTP?
😎
Ah, well, that's the issue.
If I remember correctly, you have some kind of an issue with using OSS, so you cannot use the likes of FileZilla or WinSCP, is that right?
😎
April 10, 2015 at 1:45 pm
Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀
http://www.sqlservercentral.com/Forums/FindPost1676220.aspx
But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.
April 10, 2015 at 1:53 pm
Luis Cazares (4/10/2015)
Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀http://www.sqlservercentral.com/Forums/FindPost1676220.aspx
But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.
Well you can have two clustered indexes on a table.
Clustered XML Index and a Clustered (traditional sense) Index would be one means.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 10, 2015 at 1:56 pm
SQLRNNR (4/10/2015)
Luis Cazares (4/10/2015)
Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀http://www.sqlservercentral.com/Forums/FindPost1676220.aspx
But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.
Well you can have two clustered indexes on a table.
Clustered XML Index and a Clustered (traditional sense) Index would be one means.
My bet is that Luis got it right, damn, I do want two of what Grant is on:blink:
😎
April 10, 2015 at 2:11 pm
SQLRNNR (4/10/2015)
Luis Cazares (4/10/2015)
Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀http://www.sqlservercentral.com/Forums/FindPost1676220.aspx
But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.
Well you can have two clustered indexes on a table.
Clustered XML Index and a Clustered (traditional sense) Index would be one means.
Except that clustered XML indexes are called Primary XML Indexes. 😛
April 10, 2015 at 2:14 pm
Luis Cazares (4/10/2015)
SQLRNNR (4/10/2015)
Luis Cazares (4/10/2015)
Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀http://www.sqlservercentral.com/Forums/FindPost1676220.aspx
But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.
Well you can have two clustered indexes on a table.
Clustered XML Index and a Clustered (traditional sense) Index would be one means.
Except that clustered XML indexes are called Primary XML Indexes. 😛
As I said, what ever Grant is on is going to turn any heap into a cluster:-P
😎
April 10, 2015 at 2:19 pm
Luis Cazares (4/10/2015)
SQLRNNR (4/10/2015)
Luis Cazares (4/10/2015)
Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀http://www.sqlservercentral.com/Forums/FindPost1676220.aspx
But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.
Well you can have two clustered indexes on a table.
Clustered XML Index and a Clustered (traditional sense) Index would be one means.
Except that clustered XML indexes are called Primary XML Indexes. 😛
There is also another trick that can be used to get 2 clustered indexes on a table (at least the same effect as 2 clustered indexes). :-D:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 10, 2015 at 2:45 pm
SQLRNNR (4/10/2015)
Luis Cazares (4/10/2015)
SQLRNNR (4/10/2015)
Luis Cazares (4/10/2015)
Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀http://www.sqlservercentral.com/Forums/FindPost1676220.aspx
But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.
Well you can have two clustered indexes on a table.
Clustered XML Index and a Clustered (traditional sense) Index would be one means.
Except that clustered XML indexes are called Primary XML Indexes. 😛
There is also another trick that can be used to get 2 clustered indexes on a table (at least the same effect as 2 clustered indexes). :-D:-D
Why not adding a Full Text and a Spatial index? On a second thought, that would be Cluttered index not Clustered:-P
😎
Viewing 15 posts - 48,166 through 48,180 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply