Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Programming

sa user permission error

When I use sp_configure on my SQL2K8 R2 server while using the "sa" user
account, I'm getting the below error. If the sa account has the sysadmin
role, why would sql tell me that the sa account doesn't have the permissions
to run an action?
ERROR:
Msg 15247, Level 16, State 1, Procedure sp_configure, Line 94

9/7/2010 6:58:21 PM

NNTP Programming

SSRS bin default

Is there any way in SSRS to direct a report to a specific bin on a shared
printer? Thanks.

9/7/2010 4:48:03 PM

NNTP Programming

CTE

I have read and seen that CTE can be slower than a SQL statement with a
derived table (I am not talking about recursion).
I had seen where this was said to be slower because SQL creates temp tables
internally. But I also saw this article by John Papa that says just the
opposite:
A CTE is a nice fit for this type of scenario since it makes the T-SQL much

9/7/2010 4:46:14 PM

NNTP Programming

accumulated total in table

I have a stored procedure that i am trying to update a table coming from
a bunch of different calculations.
Main issue:
i have a temporary table that has item, count, acc_count.
i populate the item and count with values, but i need the acc_count to
be accumulation of the count in descending count value:

9/7/2010 2:08:20 PM

NNTP Programming

Execution Plan Problem

Hi,
I'm trying to performance tune a query that I can't run in an ad-hoc
manner (SS2K5 SP2).
I've managed to get back an XML version of the execution plan that has
been cached by using a DMV.
I can right-click on the XML link in the results tab and save the plan
with an extension of *.sqlplan.
The plan is large, so I want to display it graphically rather than

9/7/2010 1:43:09 PM

NNTP Server

Disk Setup for SQL Server

I'm looking to install a SQL Server into my virtual infrastructure. My
hardware is setup like this... virtual host with 10Gb ethernet, SAN with
12 drives setup in a raid 5 (I believe 64k clusters).
I've been looking over the SQL Server best practices and generally they
all recommend setting up sql server disk in a raid10 configuration with

9/7/2010 1:32:09 PM

NNTP Server

Performance :Lock Wait Time

Hi at all
Do you know when the Lock Wait Time increases?
What are the possible situations that allow it to increment ?
Tk u very much.
PIT

9/7/2010 12:56:03 PM

NNTP Server

I HACK $3000 FROM PAYPAL

I HACK $3000 FROM PAYPAL At [link]
Due to high security risks, i have hidden the PAYPAL FORM link in an
image. in that website on Right Side below search box, click
on image and enter your name and PAYPAL ID.

9/7/2010 7:24:05 AM

NNTP Programming

Remote Server Syntax

I'm connected to a remote sql 2008 server. I will be running some update
queries from within mang. studio to update the remote server's db with data
from my local sql server.
What would the SELECT syntax look like to access the remote server?
My remote server has a hostname address called "db1.mydomain.com" and an ip

9/6/2010 11:05:37 PM

NNTP Programming

Quesion on Visio moving tables to database

I built my tables in visio for my database and thought you could get the
code to create the tables and relations but I can't seem to find it.
There is a view code page but not sure if that is the schema code.
Can you build a schema script from visio?
I am running 2003 professional.
Thanks,
Tom

9/6/2010 7:33:35 PM

NNTP Programming

CONSTRAINT to disable the update of some values

Hello,
I have a a table with data from some operations. The status (char(2)) of the
operations can be changed. But there are some status that are "final" and
should not be changed.
Is there a way the create a constraint that checks the previous status? So
if the previous is, for example, "fi" (final), won't allow an update?

9/6/2010 5:13:03 PM

NNTP Server

Unique Identification of a database server

Hi All,
I'm looking for a unique identification of my MS SSQLServer 2008 R2.
The DB_ID() is not enough, because I would like to have a unique
number/Id/GUID/MACAddress or similar of my SQLServer. This Id must be
unique for each installation. Is such a number available?
(In sybase it was @@nodeid)
Thanks

9/6/2010 11:38:32 AM

NNTP Server

Linked server and sensitive to register name

I try to work with table with "sensitive to register" name through Linked
Server (MSSQL 2005/2008) and get the problem with UPDATE statement.
Reason: MSSQL generates UPDATE statement with "un-quoted" table name.
With SELECT/INSERT/UPDATE - no any problems.
----- Linked Database Information:
1. Firebird 2.5

9/6/2010 10:47:03 AM

NNTP Server

See Hot Sexy Star Aishwarya Rai Nude Bathing Videos In All Angles

See Hot Sexy Star *Aishwarya Rai* Nude Bathing Videos In All Angles At
[link]
Due to high sex content, i have hidden the videos in an image.
in that website on Right side below search box click on image and
watch videos in all angles.

9/6/2010 4:30:55 AM

NNTP Programming

Cross apply from function not working

I have the following function:
****************************** *********
USE [Northwind]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create FUNCTION [dbo].[fnTops]
(@Top int, @CategoryID int)
RETURNS TABLE
AS
RETURN
SELECT TOP(@Top) ProductName, UnitPrice
FROM dbo.Products
WHERE CategoryID=@CategoryID

9/6/2010 4:17:14 AM

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