Marios Philippopoulos

Forum Replies Created

Viewing 15 posts - 661 through 675 (of 1,518 total)

RE: Can DBCC SHRINKFILE cause the transaction log to bloat?

MANU (4/2/2009)
Yes, it is possible as DBCC SHRINKFILE is logging database file page movement information in log file.
MJ
Thank you for the input.

April 5, 2009 at 3:36 pm

#972228
RE: Getting strange object name when running DBCC PAGE

GilaMonster (3/26/2009)
Marios Philippopoulos (3/3/2009)
I run the following to get the object name:
SELECT object_name(99)
I get the following: ALLOCATION
It's one of the GAM/SGAM/PFS pages. One of the allocation structures of the database.
This...

March 27, 2009 at 7:09 am

#967405
RE: Getting strange object name when running DBCC PAGE

Gift Peddie (3/26/2009)
GAM (1:3578624) = ALLOCATED
SGAM (1:3578625) = NOT ALLOCATED
These are in the physical index architecture check below for details from the owners of the relational engine.
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/07/08/under-the-covers-gam-sgam-and-pfs-pages.aspx
I'm getting...

March 26, 2009 at 4:57 pm

#967133
RE: Getting strange object name when running DBCC PAGE

Any ideas anyone, I haven't been able to find a satisfactory explanation to this yet.

March 26, 2009 at 3:32 pm

#967092
RE: Migrating 32-bit SQL to 64-bit SQL - Any issues?

umar iqbal (3/25/2009)
32 bit driver for oracel and syabse would not work here. if you are replicating data to or from other platform.
Thanks, we are actually only using linked...

March 25, 2009 at 10:24 am

#966098
RE: Migrating 32-bit SQL to 64-bit SQL - Any issues?

umar iqbal (3/25/2009)
memeoy configuration and drivers if you are usiing linked server. there are seperate drives for 64 bit. other than that it should not give trouble
Thank you for the...

March 25, 2009 at 10:18 am

#966093
RE: Do DBAs Still Read Techincal Books?

My dream is an audio book with subliminal messages on SQL Server: go to bed a newbie, wake up a SQL MVP! 😀

March 25, 2009 at 7:20 am

#965964
RE: A Simple Approach to SQL Server 2005 Encryption

Mike Good (3/23/2009)
I don't think so. A sysadmin is always going to be able to grant herself rights required to open the key.
So I think you'd need...

March 24, 2009 at 2:14 am

#965006
RE: A Simple Approach to SQL Server 2005 Encryption

Is there a way to prevent sysadmins (at the SQL instance level) from being able to decrypt data using the approach described in this article?
BTW, thank you for the great...

March 23, 2009 at 5:51 pm

#964907
RE: Real-Time Tracking of Tempdb Utilization Through Reporting Services

scotta_miller (3/23/2009)
Figured out the issue. I didn't understand that when the report runs you have to click one of the text boxes along the top to view data. ...

March 23, 2009 at 5:15 pm

#964893
RE: Error trapping while stopping/starting services in powershell

Mike (3/23/2009)
I think what you have will work just fine. However this is a good article on doing some error trapping in powershell. Perhaps you can get some...

March 23, 2009 at 3:32 pm

#964833
RE: Real-Time Tracking of Tempdb Utilization Through Reporting Services

scotta_miller (3/23/2009)
The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value > 0, false, true) --- I tried setting the hidden property to false and got the same result....

March 23, 2009 at 1:53 pm

#964742
RE: Real-Time Tracking of Tempdb Utilization Through Reporting Services

scotta_miller (3/23/2009)
Both, it is blank locally and on the report server.
I will run the Supp Material code later today and see if I can reproduce the issue. Will send out...

March 23, 2009 at 1:48 pm

#964731
RE: Real-Time Tracking of Tempdb Utilization Through Reporting Services

scotta_miller (3/23/2009)
The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value > 0, false, true) --- I tried setting the hidden property to false and got the same result....

March 23, 2009 at 1:27 pm

#964716
RE: Real-Time Tracking of Tempdb Utilization Through Reporting Services

scotta_miller (3/23/2009)
The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value > 0, false, true) --- I tried setting the hidden property to false and got the same result....

March 23, 2009 at 12:57 pm

#964693

Viewing 15 posts - 661 through 675 (of 1,518 total)