Welsh Corgi

Forum Replies Created

Viewing 15 posts - 856 through 870 (of 3,738 total)

RE: Convert sys.master_files size column to GB?

Thanks everyone.:-)
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, 2014 at 4:14 am

#1719952
RE: Convert sys.master_files size column to GB?

Lynn Pettis (6/7/2014)
Welsh Corgi (6/7/2014)
That is sweet. I have the sizes stored in KB's. What statement could I used to convert from KB to GB?
Thanks a bunch!
Divide twice by 1024.0.
Syntax...
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, 2014 at 1:57 am

#1719946
RE: Convert sys.master_files size column to GB?

That is sweet. I have the sizes stored in KB's. What statement could I used to convert from KB to GB?
Thanks a bunch!
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 7, 2014 at 4:42 pm

#1719930
RE: Capture Database Sizes Table with Date

Welsh Corgi (6/5/2014)
Jeffrey Williams 3188 (6/5/2014)
I think you are making it harder than it needs to be:
Select db_name(mf.database_id) As DatabaseName
, convert(int
...
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 5, 2014 at 4:49 pm

#1719501
RE: Capture Database Sizes Table with Date

Jeffrey Williams 3188 (6/5/2014)
Put the code I posted in a CTE - then use your calculations to convert it to MB/GB. Or, just wrap the calculation that is in...
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 5, 2014 at 4:29 pm

#1719498
RE: Capture Database Sizes Table with Date

Jeffrey Williams 3188 (6/5/2014)
I think you are making it harder than it needs to be:
Select db_name(mf.database_id) As DatabaseName
, convert(int
...
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 5, 2014 at 2:12 pm

#1719447
RE: Capture Database Sizes Table with Date

Thanks I'm trying t get the size in GB and store in a permanent table so capture the growth.
It should exclude the Transaction Log. (edit)
I will run it as Daily...
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 5, 2014 at 12:46 pm

#1719407
RE: Cancel Query on ReIndex - How much time for it to cancel

Or Drop and recreate.
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 2, 2014 at 11:50 am

#1718293
RE: Change Identity Property in T-SQL

You are right you can't set the Identity Property to true.
You can set the identity property to false by simply going into design mode and set the property to false.
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 20, 2014 at 10:20 pm

#1715209
RE: Change Identity Property in T-SQL

Sean Pearce (5/20/2014)
What do you mean?
Change the column that is an IDENTITY?
Add or remove an IDENTITY column?
Change the seed?
There is an Identity Property for a column it is set 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/

May 20, 2014 at 8:46 am

#1714984
RE: Select Statements OPENQUERY Hung on a Server

This is an example of one of the statements that is hung.
There are all the same but selecting from a different object.
SELECT @cnt = AS400TableCount FROM OPENQUERY(LScypR40DAT, 'SELECT COUNT(*)...
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 7, 2014 at 9:43 am

#1711573
RE: User can only see default schema in a Database (dbo)

DouglasH (4/24/2014)
Are there any DENY permissions set on the user for the other schemas?
If they try a SELECT query on one of the other schema tables (even though they can't...
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/

April 24, 2014 at 6:50 pm

#1708648
RE: Oracle Failover from Primary to Secondary Server (SSIS)

Jo Pattyn (4/12/2014)
was it Oracle TAF automatic fail over using tnsnames ?
Could you please expand on that?
I do not have control of the Oracle Servers but I can make suggestions...
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/

April 12, 2014 at 4:32 pm

#1705567
RE: Oracle Failover from Primary to Secondary Server (SSIS)

I basically came up with a solution
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/

April 11, 2014 at 1:25 pm

#1705460
RE: Opinion of use of LINQ

Sean Lange (4/4/2014)
OCTom (4/4/2014)
This is my take on LINQ to SQL. I have found that it does not handle large data sets well. It can be slow. And, because...
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/

April 4, 2014 at 6:05 pm

#1703458

Viewing 15 posts - 856 through 870 (of 3,738 total)