Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Setup

Create database at network drive?

Is it possible to create a SqlServer database at a network drive?
Thanks,
Ben

9/2/2010 1:36:03 PM

NNTP Programming

tsql help - get change or created line item

Hi All,
I have an order history file.
It has an Action column to store action performed on the order.
Order Id, Action, Date
1, Created, 8/1/10
1, Changed, 8/15/10
1, Changed, 9/1/10
What is the best t-sql to say
Give me the most recent changed date for all orders And if there is no
Changed status just give me the Created date.

9/2/2010 12:57:03 PM

NNTP Server

Small DBMS

I'm looking for a small DBMS to hold one data table with 10 columns (one of
them is the data - varchar(max) avg is 1000 chars) and another few reference
code tables.
The data table has ~1M recs.
The DBMS is to be installed on the application CD.
The application is to search a record on the table by diffrent properties

9/2/2010 9:21:03 AM

NNTP Server

Maintenance Plan and Read Only DB

I'd like to use a Maintenace plan to run DBCC + Update Statistics on my DBs,
but since i have one DB which is Read Only it stacs on that DB.
What can I do?

9/2/2010 8:01:03 AM

NNTP Server

Trapping losing commands

In our applications once in a while the commands don't get through to the SQL
Server for different reasons. Since it is an automatic process there is
nobody in the front end to rerun those command, and they are getting lost.
The rezones for the lost could be: Time out, broken connections, Deadlocks

9/2/2010 7:49:03 AM

NNTP Server

Find UnUsed Stored procedure

I have lots of unused SP in my DB and i'd like to delete them.
I need to find them.
How can I know that a Stored procedure is not used. (with the tables i look
at the DMV).
I thought to trace it by a DDL Trigger on the Execute sp event, but there is
not such a one...

9/2/2010 7:39:03 AM

NNTP Server

Varbinary(Max) Data compression

I need to compress hudge files (PDF + TIFF) stored in a varbinary field. I
found in BOL that :" Because of their size, large-value data types are
sometimes stored separately from the normal row data on special purpose
pages. Data compression is not available for the data that is stored
separately."

9/2/2010 7:35:03 AM

NNTP Server

A good database modelling tool

I am looking for a good database modelling tool in order to design an
sql server database.
What is about VISIO and which version is the best?

9/2/2010 7:32:07 AM

NNTP Programming

Get all Parent Child data of a table

Hi,
I have a table that have two column one is ParentID and other is ID .
Such that
ID Parent ID
1 1
2 1
3 1
4 2

9/2/2010 5:05:23 AM

NNTP Programming

SQL Express 2008: Select User Name to Login

Hello:
I am working through the tutorials. I have created user Mary.
The next bit is about how she can not access anything yet.
Oh, really?
I want to see what happens if she does.
I try to login under Mary and can not. The User name field is
disabled. The docs says that it is only available when logging in

9/1/2010 9:23:47 PM

NNTP Server

Sql Server Version # from dfb file

Hi all,
Q1: Is there a way to tell what version number a dbf file is?
Q2: Where can I find a list of version #'s, ex, 621 = SQL 2005
Background:
Using VS2005 and VS2010 with SQL Server 2005 Express. Somehow the DB on
the production server got updgraded. It works fine on the server but the
production boxs cannot open the db.

9/1/2010 9:07:45 PM

NNTP Server

Losing SQL connection

We have SQL 2008 server on our network and I am periodically losing
connection to SQL Server on my Win 7 PC. I will be working in and out of
SSMS all day and then all of a sudden I get "A network-related or
instance-specific error occurred while establishing a connection to SQL
Server. The server was not found.........Error: 233"

9/1/2010 8:24:06 PM

NNTP Programming

how to import emails

Hi All,
I'm being tasked with importing emails regarding service interruptions
from several different ISP's into SQL Server 2008 R2. I've never done
this before. Where should I start?
Thanks,
Eric

9/1/2010 8:08:11 PM

NNTP Programming

How to get 2 Max values?

I have following 2 tables (T1, T2) and rows:
T1 (Column: Id)
----
1
2
3
4
T2 (Columns: Id, Value)
----
1, 1
1, 2
1, 3
1, 4
2, 1
2, 2
2, 3
2, 4
3, 1
3, 2
3, 3
3, 4
4, 1
4, 2
4, 3
4, 4
The result-set I need is:
------------------------------ ---------
1, 3
1, 4
2, 3
2, 4
3, 3
3, 4
4, 3
4, 4
i.e for each Id from T1, I need 2 max values from T2.

9/1/2010 7:12:51 PM

NNTP Server

dealing with invalid dates

Hi,
Is there a way to deal with invalid dates during a select? Currently
I'm getting dates in a column in this format:
20100726 (yyyy/mm/dd)
I need to display it as 07/26/2010, so i was using this:
SELECT CONVERT(VARCHAR(10), CONVERT(datetime, startDate, 101), 101)
problem is startDate at times in not a valid date, sometimes there is

9/1/2010 6:16:26 PM

1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50
51 52 53 54 55 56

pBlogCategories

sys.books