Gail Shaw

Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 49,571 total)

RE: Issue with while loop

That's an error from Management Studio, not SQL Server itself.
To test your function, try inserting into a temp table instead. That way Management Studio doesn't have to...

January 28, 2017 at 4:40 pm

#1925501
RE: Sort order guaranteed?

Robert Frasca - Friday, January 27, 2017 7:55 AM
Would it be guaranteed that my returned values will still be in TransactionDate order...

January 28, 2017 at 4:24 pm

#1925500
RE: Cost threshold for parallelism

george.p - Friday, January 27, 2017 8:39 AM
The bit I still don't really understand is, does this matter if your CPU is...

January 28, 2017 at 4:19 pm

#1925499
RE: Are the posted questions getting worse?

Phil Parkin - Thursday, January 26, 2017 12:53 PM
Or perhaps there are plans for other options: Edit with Extreme Prejudice, Edit Like...

January 26, 2017 at 2:49 pm

#1925203
RE: Int vs Bigint

Eric M Russell - Thursday, January 26, 2017 1:17 PM
I may look back at this 10 years from now and laugh, but...

January 26, 2017 at 2:48 pm

#1925202
RE: Point Stored Procs At Read-only Instance of AG Group

In short, you don't.
The read only routing for AGs is based on connection strings, and a connection that indicates it is read only can be connected to the...

January 25, 2017 at 12:12 pm

#1924937
RE: Patch Principal and Mirror at The Same Time

_nzrdb6 - Tuesday, January 24, 2017 1:09 AM
I have synchronous mirroring between Server A and Server B and need to apply a...

January 24, 2017 at 1:58 am

#1924538
RE: Indexes

Welsh Corgi - Monday, January 23, 2017 2:58 AM
So are you telling me if a have for example an index CallID as a...

January 23, 2017 at 3:24 am

#1924346
RE: SSC Forum Updates

There seems to be something wrong with posting quotes.
Works fine when I try here, but exactly the same thing doesn't work properly in another thread: https://www.sqlservercentral.com/Forums/FindPost1852973.aspx

January 23, 2017 at 3:08 am

#1924343
RE: when we go for cross apply and when we go for inner join in sql server 2012

asrinu13 - Sunday, January 22, 2017 3:33 AM
Hi Friend, I have small doubt in sql server .
when we go for cross apply...

January 23, 2017 at 2:39 am

#1924332
RE: 2014 vs 2016 ?

WhiteLotus - Sunday, January 22, 2017 5:32 PM
By the way... when you buy sql license which value that you look at...

January 23, 2017 at 2:36 am

#1924330
RE: How to restrict access to users

Eirikur Eiriksson - Friday, January 20, 2017 12:40 AM
RECONFIGURE WITH OVERRIDE is needed for updating the Running Configuration Value.
No, it is not.

January 23, 2017 at 2:31 am

#1924324
RE: SVN and Managing Multiple Environments

Jeff Moden - Friday, January 20, 2017 6:14 AM
I guess I rambled on about my problem a bit too much. I'm still...

January 20, 2017 at 6:39 am

#1924000
RE: DBCC CHECKDB()

To be honest, if CheckDB runs successfully, there won't be any interesting output, plus you probably should run it with the NO_INFOMSGS option (the number of rows and pages in...

January 20, 2017 at 3:54 am

#1923961
RE: SQL Server Book

Eirikur Eiriksson - Thursday, January 19, 2017 10:04 PM
First thought would be the Troubleshooting SQL Server: A Guide for Accidental DBAs
😎
It...

January 20, 2017 at 3:44 am

#1923959

Viewing 15 posts - 1,846 through 1,860 (of 49,571 total)