Paul White

Forum Replies Created

Viewing 15 posts - 3,901 through 3,915 (of 8,416 total)

RE: Transactional Replication Performance

What steps have you taken to determine where the bottleneck is?

April 11, 2010 at 11:37 am

#1149736
RE: Frequently fragmented indexes

Jeff Moden (4/8/2010)
JDixon-385826 (4/8/2010)
fill factor 80 seems a little low - I would review the fill factor you are most likely cauing more page splits than needed
A low fill factor...

April 11, 2010 at 11:35 am

#1149734
RE: Detect if an instance of SQL Server has been upgraded

kiran.hegde (4/11/2010)
Probably you have answered my question.
Let me verify it and let you know.
Ok 🙂
How reliable is this approach?
Well it is documented by Microsoft in the link I gave you,...

April 11, 2010 at 11:23 am

#1149732
RE: Solid State Disks and SQL Server

Wesley Brown (4/9/2010)
If you are using Standard Edition like I am you don't get the full benefit of SQL Servers read-ahead feature.
Well that is true to some extent - but...

April 11, 2010 at 11:20 am

#1149731
RE: Subtract one result set from another

mangeshd (4/7/2010)
Most important question of all: why do you think NOT IN or EXCEPT are less performant than regular joins. I am not aware of any specific issues where LEFT...

April 11, 2010 at 10:36 am

#1149727
RE: Access Last function to SQL Server

Please see the following (very short) thread:
http://www.sqlservercentral.com/Forums/Topic893987-149-1.aspx
I posted three ways to emulate the LAST function there.
Paul

April 11, 2010 at 10:20 am

#1149724
RE: FILESTREAM Implementation with a Mapped Drive from LINUX

Reddy B (4/10/2010)
We have WAV files in LINUX. We are planning to map a drive to the Database Server using SAMBA to LINUX to access those WAV files.
Just wondering if...

April 11, 2010 at 10:12 am

#1149723
RE: Storing and comparing images in SQL Server 2008

JDixon-385826 (4/11/2010)
SQL server can handle this but typically you will have far better performance if you store the images to a file system...
It rather depends - mostly on the average...

April 11, 2010 at 10:05 am

#1149722
RE: Information_Schema and permissions

llevity (4/9/2010)
Several places, I read that "By default, info_schema will only return data user has access to". Does that mean there's a way to change that default behavior, short...

April 11, 2010 at 10:02 am

#1149719
RE: who had ever used TDE

You're welcome

April 11, 2010 at 9:56 am

#1149718
RE: Error converting the varchar value to int

Hey Ron,
There's an unfortunate typo in that function, which would result in an infinite loop!
The four quote marks should be two, or SPACE(0) - was this dynamic SQL at some...

April 11, 2010 at 9:56 am

#1149717
RE: Any script to find out the percentage completion status of backup, restore or any other jobs running in SQL Server 2000?

Sourav-657741 (4/11/2010)
Is that available in SQL Server 2000?
No.

April 11, 2010 at 9:28 am

#1149715
RE: How to calculate ranks or position?

WayneS (4/9/2010)
Nuts, do you see how things work better when you supply code that shows the problem? A lot of people that wouldn't bother with your problem...
I was one of...

April 11, 2010 at 9:04 am

#1149713
RE: who had ever used TDE

An extract from the Microsoft Technical Article Database Encryption in SQL Server 2008 Enterprise Edition
"The performance impact of TDE is minor. Because the encryption occurs at the database level, the...

April 11, 2010 at 9:00 am

#1149712
RE: Detect if an instance of SQL Server has been upgraded

The column file_guid in sys.master_files will be NULL if the database was upgraded from a previous version. Is that what you are after?

April 11, 2010 at 8:52 am

#1149710

Viewing 15 posts - 3,901 through 3,915 (of 8,416 total)