Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Setup

computer starts very slow after installing sql server

Hi,
I installed sql server 2008 r2 on my windows 7 pro. After installing this ,
my computer starts very slow, takes more than 5 min to get login screen and
another 10 min to start. How can I fix the problem?
Peter

8/27/2010 3:37:04 AM

NNTP Programming

Sometimes cte takes lone time

I have a recursive routing that normally takes less than a second but
sometimes takes around 7 seconds and there is only 3 records in the table.
Why would that be? I can't seem to make it happen by clearing the cache and
bufferes but it does happen occasionally.
****************************** **********************

8/27/2010 2:14:04 AM

NNTP Programming

Preventing infinite recursion

I have a table that I am using a CTE to get the parent/child records a
category. The problem is that a user could put in a record that would cause
infinite recursion and I am trying to find out if there is a good way to
prevent that?
For example:
Parent Child
5 29
29 5

8/27/2010 1:50:15 AM

NNTP Setup

SQL 2005 Versions

8/27/2010 1:42:03 AM

NNTP Programming

SQL Server 2005 Create Sysadmin Accounts

I have numerous SQL Server 2005 database instance that I would like to check
to see if the T1,T2,T3, and T4 user account have been created with sysadmin
permission.
If user account has been created, do not drop and recreate the user account.
Move to the next and account and make sure sysadmin permssion is the only

8/26/2010 9:50:03 PM

NNTP Programming

Select Identity

Hi there,
I need to get the information from a sql 2005 database if a column of a
table is an IDENTITY column.
Any idea how to get this information by SELECT ...?
Seem that is noch part of INFORMATION_SCHEMA.COLUMNS.
Regards,
Roger

8/26/2010 8:04:48 PM

NNTP Programming

Select

Hi,
I'm trying to get records for today and for few hours from tomorrow date, I'm
trying something as following which makes my application halted
SELECT * FROM accounts, jobs
WHERE (jobStatus != 'unconfirmed')
AND (jobs.accountId=accounts.accou ntId)
AND (jobDate BETWEEN '2010-08-22' AND '2010-08-24')

8/26/2010 7:41:20 PM

NNTP Programming

update query help

ear All
i have following DDL and sample data
[sql 2000]
create table main_tab (t_id varchar(10),fname varchar(30), lname
varchar(30), gender char(1),status smallint)
create table im_tab (t_id varchar(10),flag char(1))
insert into main_tab values('a0101','Ali','Hussain' ,'M',null)
insert into main_tab values('a0102','Noor','Inam',n ull)

8/26/2010 7:41:18 PM

NNTP Replication

Transactional replication of VLDBs

Hi Folks,
I am assigned to do a transactional replication of a large database of size
more than 4 TB and As the snapshot cannot hold the large amount of data I am
looking for better solution like initialize the database from the backup and
then perform the replication.?
Any suggestions,ideas or very good links to do this?

8/26/2010 6:03:29 PM

NNTP Server

Transactional replication of VLDBs

8/26/2010 5:17:55 PM

NNTP Server

Linked Servers

I would like to create two linked servers to the same data source. The first
linked server has fairly open access to the database. The second linked
server will have limited access to the database (readonly on one view). The
two Linked Servers would be configured to access the database through

8/26/2010 3:57:03 PM

NNTP Programming

FOR XML and the need for DISTINCT

The following code will only include the 'OFFERED' value once but it will leave a trailing comma. If the DISTINCT is
added the trailing comma is gone. Why? If the results are returned instead of placing them in the variable then both
'OFFERED' are there.
Change tblCalendar to your own numbers table.

8/26/2010 12:22:11 PM

NNTP Server

MSDB database more large after "Clean up history"

Hi,
I've a problem with system database msdb size, because after I run the
maintenance plans " Clean up history" for delete all history < 1 month, now
I've a size of 4.4gb (2.2 data and 2.2 log). Before the cleanup, msdb
database was 2gb.
On this istance I have about 1500 db and the autogrowth is set to "by 10

8/26/2010 7:28:03 AM

NNTP Server

convert(binary(4), @Number) not giving expected result

Hi
I thought the following code would give me a result of 1101 bit instead it
gave me 0x00000000D.
declare @Number int
set @Number = 13
select convert(binary(4), @Number)
select cast(@Number as binary(4))
What I wan to do is convert a integer or number to binary. (2s Compliment)
Background. I am doing this because we use BPay at work but finance uses it

8/26/2010 6:56:03 AM

NNTP Programming

SE2008: Turning Off Column Headings in SSMS Results

Hello:
I am working through the documentation. Some of the programs
iterate to give results. In each case, they display the column
headings. How can I turn that off?
Sincerely,
Gene Wirchenko

8/25/2010 10:06:37 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

pBlogCategories

sys.books