SQLRNNR

Forum Replies Created

Viewing 15 posts - 1,471 through 1,485 (of 19,564 total)

RE: Today's Random Word!

snake

March 30, 2015 at 5:11 pm

#1787522
RE: Sql server 2005 --> 2014 upgrade. Risks/things to consider/etc...

jellybean (3/30/2015)
If I can summarise. You can upgrade from Sql Server 2005 SP4 to Sql Server 2014. However it changes the compatibility mode to that of SQL Server 2008 -...

March 30, 2015 at 4:57 pm

#1787518
RE: Sql server 2005 --> 2014 upgrade. Risks/things to consider/etc...

Kris Gruttemeyer (3/30/2015)
SQLRNNR (3/30/2015)
The documentation poses an interesting conundrum for which I previously submitted connect items (MS closed saying they won't fix).
If you try to change to compat 90 (sql...

March 30, 2015 at 11:19 am

#1787438
RE: Sql server 2005 --> 2014 upgrade. Risks/things to consider/etc...

The documentation poses an interesting conundrum for which I previously submitted connect items (MS closed saying they won't fix).
If you try to change to compat 90 (sql 2005) you will...

March 30, 2015 at 10:59 am

#1787432
RE: sp_who3 does not show any active processes?

Welsh Corgi (3/30/2015)
Eirikur Eiriksson (3/29/2015)
Welsh Corgi (3/28/2015)
Lowell,
I have googled and googled.
I can't find one.
Do you have a link to one that works?
Thanks.
First result I got was A Better sp_who2 using...

March 30, 2015 at 9:41 am

#1787405
RE: Sql server 2005 --> 2014 upgrade. Risks/things to consider/etc...

To get to 2014, you will need to upgrade to 2008 or R2 first.
There is not a direct upgrade path to 2014 from 2005 (2005 compat mode is not even...

March 30, 2015 at 9:25 am

#1787396
RE: split value into two columns

What have you tried to do so far to make it work?

March 30, 2015 at 7:47 am

#1787348
RE: CTE Syntax

Eirikur Eiriksson (3/30/2015)
;With due respect, additional and extra semicolons between statements will not cause any problems and CTE statements will run, without the semicolon it will not.
😎
A CTE will run...

March 30, 2015 at 7:40 am

#1787342
RE: CTE Syntax

sipas (3/30/2015)
Koen Verbeeck (3/30/2015)
Such a bad habit to start a CTE with
;WITH
I hate it 😀
Nice question though, thanks Steve.
+1 - maybe part of the answer should be promoting the correct...

March 30, 2015 at 7:37 am

#1787341
RE: CTE Syntax

GilaMonster (3/30/2015)
Koen Verbeeck (3/30/2015)
Such a bad habit to start a CTE with
;WITH
I hate it 😀
.This .It's a statement terminator .It has no place at the beginning of statements .I can't...

March 30, 2015 at 7:33 am

#1787338
RE: Today's Random Word!

fruition

March 27, 2015 at 3:44 pm

#1787052
RE: Today's Random Word!

Tandy

March 27, 2015 at 12:24 pm

#1787014
RE: Are the posted questions getting worse?

Did you guys hear about this awesome new feature in SQL Server called indexed views? It is so awesome that you can create 999 indexes on a view and...

March 27, 2015 at 11:37 am

#1787007
RE: Are the posted questions getting worse?

Luis Cazares (3/27/2015)
In a different order of ideas, I want to share with you my happiness.
Starting on April 21st I'll be working in the US. I'll make a stop at...

March 27, 2015 at 10:31 am

#1786979
RE: Are the posted questions getting worse?

Brandie Tarvin (3/27/2015)
Eirikur Eiriksson (3/27/2015)
My Friday fun version:rolleyes:
IF EXISTS (SELECT 1 FROM (VALUES(CAST(1 AS BIT))) d (n)) SELECT 1 FROM sys.all_columns X,sys.columns Y,sys.computed_columns Z
AWESOME!!!!!!!
Yes you can certainly get a red...

March 27, 2015 at 10:07 am

#1786968

Viewing 15 posts - 1,471 through 1,485 (of 19,564 total)