Viewing 15 posts - 1,891 through 1,905 (of 3,060 total)
Time ago I found this piece of code...
---------------------------------------------------------
-- HOW TO - Get SS IP ADDRESS
-- Credit to Eli Leiba
---------------------------------------------------------
-- You will need this procedure...
create Procedure sp_get_ip_address (@ip varchar(40) out)
as
begin
Declare @ipLine...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 4, 2010 at 5:55 am
Duplicate post
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 3, 2010 at 12:42 pm
John Waclawski (6/3/2010)
PRINT 'If you need to Add/Delete/Modify a database on this server,'
...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 3, 2010 at 12:41 pm
I'm not an expert but I understand you can run 32 bit client in a 64 bit O/S IF you enable 64 bit mode via Enable32bitAppOnWin64
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 3, 2010 at 11:17 am
ankitwaitshere (4/29/2010)
There is a transaction intensive database - used for both routine transactions and reports.
I was wondering if I could isolate these two operations and 2 independent...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 2, 2010 at 3:31 pm
This is a SSIS generated query.
Query creation may be tricky some times.
In this particular case I'm guessing that the developer...
1- Left space for a WHERE condition on the outer query,...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 2, 2010 at 3:01 pm
Good! I"ll keep my fingers crossed 😀
If possible I would go with a three tier development model: Dev, Test, Prod.
Let developers play in Dev but only DBA has the...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 1, 2010 at 2:16 pm
Let me start by saying I totally agree with you - it will be nice to transform your free-range environment into a pro environment.
Having said that, let me ask the...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 1, 2010 at 12:18 pm
msforumpost (5/31/2010)So what is happening is over a period of time, the number of records in the table has increased whether the user choses to delete or update and the...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 1, 2010 at 11:57 am
Grant Fritchey (5/30/2010)
... he's just repeating what the MS documentation says about the long term storage facility within SCOM. It calls it the datawarehouse.
You are right - Thank you for...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 1, 2010 at 11:50 am
Barry G Freeman (5/27/2010)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2010 at 3:01 pm
lrodriguessp (5/28/2010)
Partition Function:
CREATE PARTITION FUNCTION pf_Date (datetime) AS
RANGE right FOR VALUES (2007-01-01', '2008-01-01', '2009-01-01' );
GO
Partition Scheme:
CREATE PARTITION SCHEME...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2010 at 2:52 pm
varkstad (5/28/2010)
kurs.utbetalning.grundlon = kurs.lonekat.manadslon
kurs.utbetalning.bonus = kurs.produkt.provision * kurs.lonekat.provisionsandel
kurs.utbetalning totallon = kursutbetalning grundlon + kurs.utbetalning.bonus
:pinch: Problem here is either lack of business specifications or faulty database design.
I cannot see how...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2010 at 2:37 pm
lrodriguessp (5/28/2010)
CREATE TABLE Sales (SalesID int not null
SalesDate datetime not null
CONSTRAINT PK_SalesID PRIMARY KEY CLUSTERED (CPFCNPJ)
)
on ps_Date(SalesDate)
CLUSTERED?...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2010 at 2:18 pm
abhisek_boy_in (5/28/2010)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2010 at 2:04 pm
Viewing 15 posts - 1,891 through 1,905 (of 3,060 total)