Viewing 15 posts - 616 through 630 (of 3,738 total)
My main concern is not having SSMS on the Server and the learning curve to use command line.
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/
June 12, 2015 at 10:00 am
How do I get a version that only shows active connections?
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/
June 12, 2015 at 9:46 am
spaghettidba (6/12/2015)
What's the problem? The sleeping tasks? Can you please clarify your issue?
I'm showing task that are still connected but they are not doing anything.
It is acting like sp_who2.
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/
June 12, 2015 at 9:19 am
Shawn Melton (6/12/2015)
Just go download Sp_WhoIsActive and use it.
I already have it and I have been using it for years.
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/
June 12, 2015 at 9:18 am
I challenged them why they was to encrypt the entire database.
I was told that it was a Business requirement handed down from Corporate.
What are some of CONS of doing this?
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/
June 9, 2015 at 7:31 am
I'm sorry but what are you asking/telling me?
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/
June 9, 2015 at 6:00 am
There are a lot of negative as backup and restore.Thanks for setting me straight.
I used encryption to encrypt a data element. and that went pretty smooth.
I did not want to...
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/
June 9, 2015 at 5:49 am
Perry Whittle (6/9/2015)
TDE does not enable Table Data Encryption, it enables Transparent Database Encryption.Do you understand what it does and why you would enable it would be my initial question?
Yes...
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/
June 9, 2015 at 5:34 am
It works.
I had to go and accidently clicked too soon.
Lynn Pettis (6/8/2015)
Welsh Corgi (6/8/2015)
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Encrypt01!@'
CREATE CERTIFICATE CERT05 WITH SUBJECT = 'Cert4u12!@'
USE Adventureworks2012
CREATE DATABASE...
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/
June 8, 2015 at 3:02 pm
USE MASTER
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Encrypt01!@'
CREATE CERTIFICATE CERT05 WITH SUBJECT = 'Cert4u12!@'
USE Adventureworks2012
CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_256 -- Error
ENCRYPTION BY SERVER CERTIFICATE TDECert
USE MASTER
ALTER...
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/
June 8, 2015 at 2:10 pm
I included the script for testing.
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/
June 8, 2015 at 12:54 pm
Thank you. I appreciate your feedback. Excuse me.
I was just trying to make it easier this is a very interesting subject.:-)
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/
June 1, 2015 at 12:54 am
olibbhq (5/31/2015)
Thanks for all your help, I took the example content from wikipedia but all the content I want to put into a table is in the format. Essentially I...
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/
May 31, 2015 at 4:03 am
Why do you think you need that you do not need to use SSIS?
If you get your date in a simplified format you can use the Import Wizard To load...
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/
May 31, 2015 at 3:47 am
olibbhq (5/31/2015)
Thanks for all your help, I took the example content from wikipedia but all the content I want to put into a table is in the format. Essentially I...
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/
May 31, 2015 at 3:33 am
Viewing 15 posts - 616 through 630 (of 3,738 total)