Lynn Pettis

Forum Replies Created

Viewing 15 posts - 3,466 through 3,480 (of 26,490 total)

RE: LOB data types

navtec (8/25/2016)
max length for the varchar(max) and nvarchar(max) columns are 8000.
I was hoping they would be -1.....
Not any where I have seen. I am pulling this info on a...

August 25, 2016 at 10:24 am

#1897550
RE: LOB data types

FYI: https://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(SYS.TYPES_TSQL);k(SQL12.SWB.TSQLRESULTS.F1);k(SQL12.SWB.TSQLQUERY.F1);k(MISCELLANEOUSFILESPROJECT);k(DevLang-TSQL)&rd=true

August 25, 2016 at 10:21 am

#1897547
RE: LOB data types

navtec (8/25/2016)
When I run John's query against my test table (which contains a VARCHAR(MAX) data type column in it), it returns the data type as 'varchar'.
So it seems to miss...

August 25, 2016 at 10:16 am

#1897541
RE: Are the posted questions getting worse?

Grant Fritchey (8/25/2016)
Lynn Pettis (8/25/2016)
Anyone hear from spagettidba??
The news from Italy keeps getting worse.
And I just got a tweet from him.
Thanks, Grant. If he is tweeting, he must be...

August 25, 2016 at 8:53 am

#1897492
RE: Are the posted questions getting worse?

Anyone hear from spagettidba??
The news from Italy keeps getting worse.

August 25, 2016 at 8:07 am

#1897476
RE: Are the posted questions getting worse?

Hearing about the earthquake in Italy, hope all our friends back there are safe.

August 24, 2016 at 8:40 am

#1897216
RE: Are the posted questions getting worse?

Luis Cazares (8/23/2016)
Gail, you just made my day with this answer. http://www.sqlservercentral.com/Forums/FindPost1811748.aspx
I can't stop laughing. 😀
omg

August 23, 2016 at 12:31 pm

#1897000
RE: Invalid use of a side-effecting operator 'INSERT EXEC' within a function:

Ray Herring (8/22/2016)
This one sure generated a lot of discussion but I don't think (at least I did not see) that anyone addressed the actual code problem in the UDF...

August 22, 2016 at 5:03 pm

#1896783
RE: Are the posted questions getting worse?

TomThomson (8/20/2016)
Brandie Tarvin (8/19/2016)
Lynn Pettis (8/19/2016)
And then we have people that think they can learn our job from a book.
blink
blinkblink
Ummmm, that's how I learned it. Books and a small PC...

August 22, 2016 at 7:22 am

#1896639
RE: Is SQL Server Replication going away?

Jeff Moden (8/21/2016)
Lynn Pettis (8/19/2016)
Jeff Moden (8/19/2016)
pooyan_pdm (8/19/2016)
This is a gray area. Replication is deprecated and there's no true replacement for it at this time.
Not using Replication in future...

August 22, 2016 at 12:00 am

#1896555
RE: Column Invalid Error...but Column Exists

Check the mapping to the new fact table in your SSIS package.

August 19, 2016 at 1:30 pm

#1896440
RE: Is SQL Server Replication going away?

Jeff Moden (8/19/2016)
pooyan_pdm (8/19/2016)
This is a gray area. Replication is deprecated and there's no true replacement for it at this time.
Not using Replication in future deployments is based on...

August 19, 2016 at 1:29 pm

#1896439
RE: Are the posted questions getting worse?

Lynn Pettis (8/19/2016)
Sean Lange (8/19/2016)
Brandie Tarvin (8/19/2016)
Lynn Pettis (8/19/2016)
And then we have people that think they can learn our job from a book.
blink
blinkblink
Ummmm, that's how I learned it. Books and...

August 19, 2016 at 10:20 am

#1896393
RE: Are the posted questions getting worse?

Sean Lange (8/19/2016)
Brandie Tarvin (8/19/2016)
Lynn Pettis (8/19/2016)
And then we have people that think they can learn our job from a book.
blink
blinkblink
Ummmm, that's how I learned it. Books and a small...

August 19, 2016 at 10:16 am

#1896390
RE: Are the posted questions getting worse?

Brandie Tarvin (8/19/2016)
I have once again learned the value of being part of a SQL forum. Specifically this site.
New project. Take a feed I already created and make sure that...

August 19, 2016 at 10:14 am

#1896389

Viewing 15 posts - 3,466 through 3,480 (of 26,490 total)