R Language

Technical Article

RE: Hardware Requirements For SQL Server 2000

  • Reply

I looked through some stats I keep and came up with a number (based on 3 fact tables 20 columns/12 million rows and a couple dim tables) =5.75 GB.Don't forget Growth % and db bkp file space.200GB would be plenty.  I wouldn't under sell myself on space.  Seems like dw projects grow as the audience […]

2005-02-17

Technical Article

RE: Temp Tables or Something Else ??

  • Reply

I have been doing it for the past two years using the method described by Phil.  It's fast and very effecient.  Just remember to either truncate the loader table first (I actually run a truncate before and after the loads just in case) Marvin

2005-02-17

Technical Article

RE: Record Usage of a Stored Procedure

  • Reply

Hi there,We ran across the same situation - wanting to record use of a stored procedure, including its final status. Originally, we just added a line to the stored procedure that recorded its own execution in a log table, but that failed if the transaction rolled back for anything.Now we have a "header" procedure that […]

2005-02-17

Technical Article

RE: Openquery and using variables

  • Reply

My Linked Server name and sql query change. Even if I write multiple queries to fulfill all the conditions, I am still left with the linked server name as a variable?The latest thing is to use four-part name. Can I supply variables to do that job?We do not want the server locations to be hard […]

2005-02-16

Technical Article

RE: Timestamp on threads

  • Reply

Frank - I understand. We are planning another addition to our family and I share the household duties. The wife works (sometimes longer hours than I do). I, too, have the stories - Cinderella and Snow White are big, my favorite Alice was kind of a dud.

2005-02-14

Technical Article

RE: Active/Active sql cluster configuration. Virtual sql server IP addresses

  • Reply

Ok thanks again. It looks like my work hours come to end. Tomorrow I'll try to reconfigure MS DTC. Friendly speaking I don't understand why MSDTC needs separate IP address, but if it want it, it will get oneThank you for your help. It looks like you are my personal adviser. I'm very grateful to you

2005-02-10

Blogs

Encrypting Your SQL Data Should be Your Default Option

By

Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...

Power BI Embedded: Using Row-Level Security for Multilingual Reports

By

Making multilingual reports in Power BI requires a lot of different elements. Translations can...

Daily Coping 29 Nov 2022

By

Today’s coping tip is to make a meal using a recipe or ingredient you’ve...

Read the latest Blogs

Forums

Sql table join help

By SQL Bee

I have 2 tables . tblStudentMarksOriginal - StudID, Subject, Marks 101, english, 91 101,...

Why do Sql Server In operator behaves differently and return nothing?

By mehmood

I am using sql server 2017. I am trying to use the in operator,...

Basic Checks on a New AWS RDS SQL Server

By Br. Kenneth Igiri

Comments posted to this topic are about the item Basic Checks on a New...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers