Welsh Corgi

Forum Replies Created

Viewing 15 posts - 646 through 660 (of 3,738 total)

RE: 4 Virtual CPU's or 2 CPU's with Dual Cores

I read that licensing for SQL Server 2014 is a minimum of 4 cores per CPU.
So perhaps I could get away with that?
Does anyone see a downside to that?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 31, 2015 at 11:29 am

#1787813
RE: Migrate SSRS from 2008 R2 to SQL Server 2014

happycat59 (3/30/2015)
Welsh Corgi (3/30/2015)
Where are the encryption keys stored?
What about the configuration files?
You need to backup the encryption key using either the RS utility or the SSRS Configuration tool.
As far...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 31, 2015 at 6:40 am

#1787663
RE: Left Function and CHARINDEX

Luis Cazares (3/30/2015)
That happens when the backslash doesn't exist in the string and generates 0-1=-1 which is invalid for the parameter.
Use a safety net to prevent this and remove the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 30, 2015 at 11:56 am

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

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 DMVs (sp_who3)
😎
On...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 30, 2015 at 9:29 am

#1787400
RE: Migrate SSRS from 2008 R2 to SQL Server 2014

Where are the encryption keys stored?
What about the configuration files?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 30, 2015 at 6:55 am

#1787320
RE: Install System Databases to a non default drive

george sibbald (3/28/2015)
click on the word 'here'
just make sure you use the page that refers to your version of sql.
What?
Click on the word here? Where?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 28, 2015 at 7:32 pm

#1787135
RE: Install System Databases to a non default drive

george sibbald (3/28/2015)
Welsh Corgi (3/28/2015)
The master database is the tricyest system database to move.
I had trouble years ago do this.
What are the options?
I prefer to not do it in SSMS....
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 28, 2015 at 5:39 pm

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

Lowell,
I have googled and googled.
I can't find one.
Do you have a link to one that works?
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 28, 2015 at 3:11 pm

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

I am a Domain Admin.
I'm still trying to identify the version of sp_who3 that list the session that is performing the sp_who_3 command.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 28, 2015 at 11:49 am

#1787111
RE: Backups

Orlando Colamatteo (3/28/2015)
PS regarding your question about best practices I was not sure if you meant tools or strategy so focused on toos in my last post since you mentioned...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 28, 2015 at 11:08 am

#1787109
RE: Backups

Orlando Colamatteo (3/28/2015)
Go to http://ola.hallengren.com and check out his solution for backing up your databases and logs. I've been using it for years and it has saved me countless hours....
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 28, 2015 at 11:01 am

#1787108
RE: Install System Databases to a non default drive

The master database is the tricyest system database to move.
I had trouble years ago do this.
What are the options?
I prefer to not do it in SSMS. I did something wrong...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 28, 2015 at 10:00 am

#1787103
RE: Install System Databases to a non default drive

benjamin.reyes (3/25/2015)
You can always move them(except resource) after installation.
I saw several servers today that had the Resource Database that had been moved.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 27, 2015 at 3:29 pm

#1787047
RE: Install System Databases to a non default drive

GilaMonster (3/25/2015)
The one that lists root directory, backup directory, data directory, log directory. They're the only things on that screen and it's the default tab, so hard to miss unless...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 25, 2015 at 11:40 am

#1786389
RE: Install System Databases to a non default drive

What screen do you specify the paths?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 25, 2015 at 7:44 am

#1786306

Viewing 15 posts - 646 through 660 (of 3,738 total)