remember some tables cannot be truly 100% "backed up" all by itself due to referential constraints....any foreign keys to lookup tables, tables for city/state/etc, would require those related tables to...

AppSup_dba (2/15/2011)

---

I am running a insert query that joins some 6 tables and fetches 3LAKH rows into another table. My TEMPDB size more than 40GB. I am still getting error

Could...

Phil posted exactly what i would have...i would immediately question why your end users are using a tool to view data that is limited to 65536 rows of data;

The advantage...

CELKO (2/14/2011)

---

the scoring starts with 100 points.

1) Did the DDL follow ISO standards and have no dialect? +25

2) Did it have no key?? -25

3) Did you use ISO sex...

ok in that case, here is a solid example;

With PersonInfo(PersonID,Name,Gender)

As

(

SELECT 1, 'Fred','M' UNION ALL

SELECT 42,'Lisa','F' UNION ALL

SELECT 99, 'Pam','F' UNION ALL

SELECT 8,'Peter','M'

),

MyGuys As

(

SELECT Name FROM...

kev this really looks a little bit like a homework question, so I'll give some hints instead of a full answer, unless you confirm it's not homework 🙂

what you ...

ahh i see it.

anything between two single quotes is a literal string...

so this part never gest substituted with your values:

EXEC master.dbo.sp_addlinkedserver @server = '@ServerName,@Port_nbr'

try this instead see how i added...

you have to declare and assign the variables for TSQL:

if this is all in TSQL, you might use a cursor like this:

--#################################################################################################

--Linked server Syntax for SQL Server With Alias

--#################################################################################################

declare

@svname Nvarchar(64)

declare...

well, i would tackle it with a table defining the hours associated to a givin shift period:

/*--results

RightNow ...

SQL will use all available cores unless you tell it not to; you can select it by right clicking the server>>Properties as seen below; my machine is a single proc...

every application I've ever seen always had the components of the connection string configurable...whether it's part of the GUI, or an ini/config file, the connection strings going to be configurable...they...

I believe the client queries port 1434 and the "SQL Server Browser Service" on the server tells the client which actual port to connect to; it does't try 1433 and...

hey neat;

what you've done is create an "orphaned" user;

inside the sys tables, a unique SID is assifned to every login or user; you may have encountered this when restoring a...

no you can't...all sys.* items are read only views; MS wanted to remove the ability to update meta data tables directly, because too many times an unintended consequence resulted in...

instead of selecting from that table TBL_CYCLE_PARTS,

you instead have to select from some sort of calendar table, with all possible times, and join THAT to your TBL_CYCLE_PARTS;

this will work *i...