tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Clustering

SQL DB indexing

I have the opportunity to design or DB server with the version that will do
what we need. If I understand my information correctly, my Standard Version
for SQL 2005 Standard Edition, will not perform indexing without shutting
down the DB. Howver; Enterprise Editition, as I understand is capable of

8/30/2010 10:09:03 PM

Clustering

SQL DB indexing

I have the opportunity to design or DB server with the version that will do
what we need. If I understand my information correctly, my Standard Version
for SQL 2005 Standard Edition, will not perform indexing without shutting
down the DB. Howver; Enterprise Editition, as I understand is capable of

8/30/2010 10:09:03 PM

NNTP Programming

SELECT * in Programs

As far as I can remember, this has been a "no no". But what would you answer
developers who say " We want the program to bomb when the table is out of
sync with program definiton"?
Thanks in advance

8/30/2010 5:33:03 PM

NNTP Programming

install Business Intelligence

How to install Business Intelligence? Is Integration Service and Analysis
Service part of the BI? Do I need to pay for Business Intelligence?

8/30/2010 3:49:03 PM

NNTP Server

Problems installing "Microsoft SQL Server Management Studio Express" on Win7 64Bit,...

Hi,
first i must apologize for crossposting but i hope someone
has a answer for this: I try to install this (the 64 bit variant
on my Windows 7 64 bit):
[link]
it fails with a "Access denied". My question is: Is there any way,

8/30/2010 2:45:42 PM

NNTP Setup

Problems installing "Microsoft SQL Server Management Studio Express" on Win7 64Bit,...

Hi,
first i must apologize for crossposting but i hope someone
has a answer for this: I try to install this (the 64 bit variant
on my Windows 7 64 bit):
[link]
it fails with a "Access denied". My question is: Is there any way,

8/30/2010 2:45:42 PM

NNTP Programming

How to write this query?

Hi,
I'm using SQL Server 2005. I have a query that returns multiple rows
in which all the column values are the same except one ...
Results
id text category
=====================
2 Hello ABC
2 Hello DEF
Does anyone know how I would write this query such that I could

8/30/2010 2:43:24 PM

NNTP Programming

UNDERSTANDING MDF FILE FORMAT

Hi,
Any one knows how mdf file is structured, and how it saves data in binary
format, I am studying how to design a database. I will appreciate any link
on Internet.
Thanks and Regards,
Luqman

8/30/2010 2:59:52 AM

NNTP Programming

sql help required

sql 2000
i have following 2 tables
CREATE TABLE [idtab] (
[uid] [int] NOT NULL ,
[uid2] [int] NOT NULL ,
[system] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
CONSTRAINT [PK_idtab] PRIMARY KEY CLUSTERED
(
[uid],
[uid2],
[system]
) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [sectab] (

8/29/2010 11:54:29 PM

NNTP Programming

help with sq

*** Sent via Developersdex [link] ***

8/29/2010 11:44:18 PM

NNTP Server

laying out iscsi drives for SQL

Is there a best practice for laying out a disk structure on a Windows Target
server for an SQL server initiator's drives? Point being, when configuring
the drives on the iSCSI Host, you format them as the VHD, then should you
format the drives the same way as on the initiator, in this case an 2008 SQL

8/29/2010 9:40:06 PM

NNTP Programming

Energy Saving Tips

1. Reduce heater's room temperature
For each extra degree (Celsius) of temperature, your heater will
consume 7 to 11%
more energy. Adjust it to 18degrees which is also better for your
health.
2. Install a programmable thermostat
You will be able to control the heater's temperature during specific
hours every day.

8/29/2010 9:11:42 PM

NNTP Programming

Which service pack is installed

How can i know on sql server which service pack is installed?

8/29/2010 10:50:37 AM

NNTP Programming

table error problem

Hello there
I have procedure who create temp table #tmp, store a lot of data inside it
for moving it to another database.
on any 5 rerun of the procedure in job i'm getting an error like: Attempt to
fetch logical page (1:73868) in database 2 failed. It belongs to allocation
unit 72057594108903424 not to 72057594124763136

8/29/2010 8:17:47 AM

NNTP Programming

CELKO, I have a problem with your book "Analytics & OLAP in SQL"

CELKO, your Analytics & OLAP in SQL book arrived last week and I
started reading it today. Unfortunately, pages 13 through 60 are
missing. Could you possibly replace it for me, or perhaps send me a
PDF of the missing pages? I need to read it sooner rather than later.

8/29/2010 12:52:07 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