FAQ - Frequently Given Answers

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

Site Related Discussions

FAQ - Frequently Given Answers

Author

Topic

Kristen
Test

22859 Posts

Posted - 2005-08-03 : 05:33:46

I have moved this to http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210

And I removed all Highlighted Changes

Kristen

How to

How to get Images or blobs into SQL table
Inserting Images as BLOB in SQL server table
Article: Images and SQL Server * 07Sep2005 Changed Forum Link to Article
How to use DeBUG window in QUERY Analyzer
Use a Parameter in the Top clause *
Dynamic SQL or How do I SELECT TOP @var records? *
Can't insert NULL into table with unique key
Efficient paging of recordsets with T-SQL *

CSV / Splitting delimited lists
WHERE IN @MyCSV
Article: Passing a CSV or Array to a Stored Procedure
Best split functions*
and Concatenating data from rows with same GroupBy column *

trigger to keep tables matching
Triggers to audit changes *
Make a copy of my DB

Article: Identity and Primary Keys
Article: Sending SMTP Mail using a Stored Procedure
Article: Dynamic ORDER BY
Article: More Trees & Hierarchies in SQL
Article: Using SELECT to INSERT records
Article: Deleting Duplicate Records * 08Sep2005
Article: Returning a Row Number in a Query
Article: Calculating Running Totals

Datatypes

GUIDs

Datatypes - Dates

Date formatting
Format Date/Time
last date of the month
Getting the date portion of a datetime value * or
Round a date to Year, Quarter, Month, Day, Hour or Minute * 09Sep2005 Added
How to get date in t-sql
compare date with current date
convert varchar to datetime
Compare dates regardless of time?
Convert varchar to date
Time in Analog
Start of Week Function
Earlier date than 1/1/1753 * 27Aug2005

Techniques

Cursor or Not
TSQL/ SP Best Practices
case-sensitive
User-Defined string Functions Transact-SQL
Passing an array into a stored procedure
Comparing two tables or views easily
All Tables in All Databases
Better Phonetic Matching Algorithm (A better Soundex)
Levenshtein Edit Distance Algorithm (A better Soundex)
Find tables with no PK
Function: HTMLDecode
How to protect errorlogs to tables from rollbacks

Developer / Techie stuff

Wrong collation
Best SQL Security Method
Some query optimalisation
Requirements for Horiztonal Partitions * 13Sep2005
Multiple SQL Server 2000 Instances
Primary Key v. Unique Index
HOWTO Run SQL Profiler without sysadmin rights
upgrade from SQL7 to SQL2000
xp_cmdshell execute right
Monitor object usage over time
size of user tables in a database
Changing Column Length

Why I'm not a DBA
Do you S-Q-L or Sequel
Interview questions
Best steps to becoming a DBA
Add, Sub, Mul, Div With Really! Big Numbers

Developer / Techie stuff - Collation

different Collation Settings between Databases
how to change Collate on the server
Cannot resolve collation conflict for equal to OP
How to change default collate in SQL

Database Design and Structures

Hierarchies
Normalisation
NULL opinion?
Finding evidence of sql injection attack *

Mechanics

how does row locking work

EMail

sp sending mail
CDOSYS Send Email

XML

SQL Server 2000 XML
Adding an XML Root Tag*
Handling tricky namespaces in OpenXML*

Backup / Restore / Replication / Jobs / Houskeeping

RESTORE syntax / example * 27Aug2005
Unable to restore/attach a MDF file (single file attach / sp_attach_single_file_db) *
deleting replication
Shrink database
Shrink a large Log File / .LDF
Massive msdbdata.mdf *
Rebuilding Indexes *
DBCC CHECDB, CHECKTABLE, NEWALLOC (old)
how long will take to restore a 10 gb? *
Log Shipping -Shrinking Log and Data files
Backing UP SQL Server to another server *
Suspect Databases after Power Cut? *
Jobs failing
Reindex All Tables in All Databases (old)
Fix Orphaned Users * (bit old)
All I have is the .bak file *
Restoring .BAK file to a different server? *

Export / Import / DTS

Copying/backing up DTS Packages
Export to Excel
Generate INSERT statements... * (so-so)
Tool to script database records? (i.e. generate INSERT statement script) *
How to convert DATE Format from DD/MM/YY to MM/DD/YY in DTS
Importing an Excel File with DTS
Is DTS Secure for credit card backup to Access?
Winzip in scheduled DTS Package
Article: Using BULK INSERT to Load a Text File

Output / Reporting / Formatting

Pivot table
Article: Dynamic Cross-Tabs/Pivot Tables

Error Messages

SQL Server does not exist or access denied

Connections

Linked Server Newbie Question

Configuration / Hardware

SQL Server Standard & 4GB memory *
Using AWE option in SQL *
Increasing SQL Server Memory *

MSDE

MSDE Setup fails
MSDE Install Issue
Installing MSDE on XP Pro
Backing up MSDE database

SQL 2005 / Yukon

Does Yukon/SQL2005 support paging recordsets
SELECT * not allowed in Yukon/SQL2005?
Download Yukon/SQL2005
SQL Server Management Studio

MySQL, Oracle, and the others

MySQL not as good as MS SQL? *
Migrating from Oracle to SQL Server *

Other

SQL Reporting Service SP2?

Got an hour .. or ten ... to spare?

Would you work at Elwoo's office?

*
Simple Quiz*

*=Article checked and known to be relevant and useful for its topic! Not many as yet ... but I'm working on them. Ones I have recently marked up are in Teal

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-08-03 : 05:36:09

Kristen.... WOW!!

that's a lot of links....

Go with the flow & have fun! Else fight the flow

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-03 : 05:44:57

Well Done Kristen
You make things easy

Madhivanan

Failing to plan is Planning to fail

Kristen
Test

22859 Posts

Posted - 2005-08-03 : 06:47:02

"that's a lot of links...."

Well, just intended as a "proof of concept" really ...

I'd appreciate comments on what you think of the IDEA (rather than the actual things the links point to!!)

Kristen

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-08-03 : 06:52:56

I like it. Are you going to have a page somewhere or are you going to keep editing this thread?

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2005-08-03 : 06:54:18

Ja - Kristen - I reckon this needs to be blogged

Duane.

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2005-08-03 : 08:32:20

I could definitely see that as a sticky topic in the 'New To SQLTeam' forum...

but I don't think it belongs in a blog. Most of the vagrant viewers won't make it to a blog...

Corey

Co-worker on The Wizard of Oz "...those three midgets that came out and danced, the freaked me out when I was little. But they are ok now."

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2005-08-03 : 08:43:55

>> Most of the vagrant viewers won't make it to a blog

I beg to differ.

People who have blogs at other sites - constantly browse our blogs and make refference to posts on our blogs.
And that in turn means more hits from a google search

Trust me - I know

Duane.

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2005-08-03 : 09:01:49

k.... i'll take your word for it

Corey

Co-worker on The Wizard of Oz "...those three midgets that came out and danced, the freaked me out when I was little. But they are ok now."

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2005-08-03 : 09:21:32

quote:
Would you work at Elwoo's office?

Hey - don't think that one's finished by a long chalk matey. One of them is now off work with Stress AND I didn't say a thing to him (honest)

More seriously can I propose [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag04/html/InjectionProtection.asp[/url] as a sticky (or something closely related to it)

steve

Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer.

Kristen
Test

22859 Posts

Posted - 2005-08-03 : 12:19:10

I would hate it to be in a blogg.

However, referencing the core posts from a Blog would be cool

Reasons being:

This is about enabling a user who is about to post in a forum finding an answer first, and going away happy. Or being "sent to the sticky" to find the answer.

I spend a long time hunting down URLs for answers, it would be great if I could just say "The answer to your problem is in the Sticky at the top of this Forum" and not have to find the exact URL of some blogg entry, or at a remote site.

Possibly (depending on the permissions assigned to the Stickies) anyone could add a new link to [their own message in] the sticky thread - with a Blog (or the FAQ on the main site) we are dependant on someone getting around to it.

And lastly, I don't think its got anything to do with on-going education or frequent visitors, its about answering recurring questions. So, yes I would agree that a newly added link to a "really cool explanatory thread" might also be a good candidate for someone to add to their blog, I don't think the standard list of Frequently Given Answers should be in one person's blog.

Re: Google

It currently spiders all over the site without much trouble, so I don't think it needs a helping hand for this particular job, or am I missing something?

Kristen

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-08-09 : 07:02:46

WOW!!! Missed this.

What would be nice as well, is a link page to all the SQL challenges posted over time...

rockmoose

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2005-08-09 : 09:18:42

Oh yeah... I love those things... so much wasted time though

Corey

Co-worker on The Wizard of Oz "...those three midgets that came out and danced, the freaked me out when I was little. But they are ok now."

Kristen
Test

22859 Posts

Posted - 2005-08-09 : 14:10:53

Hehehe ... so my category "Got an hour .. or ten ... to spare?" fits OK then?!

Kristen

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-08-23 : 07:43:11

Kristen
Can you identify the revisions/additions you make when you edit this list above?...(please!)
I can't figure out what's new....

Andrew

Kristen
Test

22859 Posts

Posted - 2005-08-24 : 08:05:42

Good idea - Sorry, I was "improving" it for my convenience, but most of what is there is checked / reasonable etc. now so I'll put a date next to anything I add from now on

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources