Showing posts with label pretty. Show all posts
Showing posts with label pretty. Show all posts

Tuesday, March 20, 2012

Book

I read alot of Technical books on SQL and I have found that SQL for dummies is actually a pretty good book(nice reference)I wouldn't even bother with books any more after you're done with that one. By the time they come out the "solutions" that were published there become either obsolete or not as efficient as the ones that you can find on web sites. Besides, I just love when a book claims to be "The Ultimate", "The Final", "The Most Comprehensive", etc. and then when attempting to discuss a certain aspect of the architecture states that "this topic is outside of scope of this book..." Go figure, hey?! Web sites on the other hand are free and plenty, so are boards like this one.

Thursday, March 8, 2012

Blocking 101

Pretty new to SQL Server and support multiple applications on SQL Server.
Just encountered a situation where "blocking" was occurring.
Can someone provide me more information or a link explaining Blocking and
how I can use SQL Server Enterprise Manager to determine who and what is
causing the blocking.
Any help is appreciated and I Thank You in advance for your help.
wnfisbaINF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
http://support.microsoft.com/defaul...kb;EN-US;224453
Typically, it's caused by long running transactions that hold row, page or
table locks.
"wnfisba" <wnfisba@.discussions.microsoft.com> wrote in message
news:2DC94438-B2D4-4BEE-A781-AC16DE69A7B7@.microsoft.com...
> Pretty new to SQL Server and support multiple applications on SQL Server.
> Just encountered a situation where "blocking" was occurring.
> Can someone provide me more information or a link explaining Blocking and
> how I can use SQL Server Enterprise Manager to determine who and what is
> causing the blocking.
> Any help is appreciated and I Thank You in advance for your help.
> wnfisba

Saturday, February 25, 2012

BLOB fields - questions

Hi,

Ok, I am pretty new to BLOB's on SQL SERVER 200 so I need some answeres.

1. Can BLOB Fields hold .doc and/or .pdf documents?
2. If yes, can the contents of the documents be searchable.
3. If documents are updated do BLOB Fields lengtht change/grow dynamically?

I would apreciate any answers in this matter and if possible examples were I can get a better idea on how to configure the BLOB fieds on my DB and/or documentation regarding BLOB's.

Thank you, Pepe.I am far from an expert in BLOB fields but here is my understanding of them. If there are any other gurus out there I will follow with interest as it is not something I have had cause to use/do yet.

1. Being Binary Large Objects I believe a BLOB field should be able to hold a pointer to a .doc or .pdf file.

2. I don't think you can search on the BLOB field as it is only a pointer to the actuall file. I seem to remember form somewhere though that you may be able to search them if it is full text indexed. (Don't quote me on that though)

3. As the table only stores a pointer to the BLOB the length of the field doesn't change when the file changes.

Sorry can't supply any examples for using or configuring BLOB fields|||If you want to learn more on this topic check the following link:

Brief tutorial on using text, ntext, and image data types (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro03/html/sp03g8.asp)|||Hi,

I need to upload .doc files to a BLOB field.
Does anyone know a way to do this? I guess I could use plain Insert commands from SQL Query Analyzer. Alternately, I want to use VB.NET to create an interface for the user to upload this .docs and to retrieve them.

Thank you and I would appreciate some examples if possible.

Pepe.|||ok, since you're saying whatever the website shows is not enough, here is what i came up with when i needed something similar to store various types of documents.

Friday, February 10, 2012

Bit more specific, Can one pass an NVARCHAR to IF UPDATED()?

Question is pretty much in the thread title.

I'm still plunking away on a history trigger that requires the evaluation of whether or not each column has been updated. If it has,t hen I'll be tossing a record into a history table.

Basically I need something to function along the same logic as this:

IF UPDATED(@.s)
BEGIN
--some code
END

Any thoughts you folks may have are greatly appreciated.About the closest I can get is the Columns_Updated() and maybe some fancy dancing with syscolumns.

-PatP|||About the closest I can get is the Columns_Updated() and maybe some fancy dancing with syscolumns.

-PatP

At least it's something to go on. I'll take a look at it tomorrow.

Much obliged good sir.