Questions in topic: tables - SQL Server Q&A from the SQL Server Central community

x

login about faq Site discussion (meta-askssc)

Questions in topic: tables

1

votes

3

answers

109

views

I need to change a table name, how do I change all references to that table in views and sprocs?

Apr 25 at 10:18 AM Ian Roke 1.7k

sql-server-2005 tables

4

votes

1

answers

83

views

Delete a lot of Tables

Feb 20 at 08:01 PM Pavel Pawlowski 20.3k

tables

2

votes

2

answers

142

views

Why space more for staging Table compared to main tables

Feb 20 at 07:44 PM Pavel Pawlowski 20.3k

ssis tables tablespace

3

votes

2

answers

218

views

Deleting blank rows from sql server 2005 table.

Feb 06 at 11:54 AM ThomasRushton ♦ 29.3k

tables

0

votes

1

answers

142

views

How to return the most common value for every column in every table in a DB

Dec 07 '12 at 06:00 PM ACV24 0

tables

0

votes

2

answers

331

views

Delete data without delete tables

Nov 08 '12 at 09:26 AM Fatherjack ♦♦ 38.8k

sql-server-2005 sql tables

1

votes

2

answers

393

views

Drawbacks of creating a view on large live table

Sep 05 '12 at 09:54 AM Grant Fritchey ♦♦ 62.1k

performance views tables

2

votes

2

answers

1.2k

views

Why is the database size larger than sum of table sizes?

Jul 09 '12 at 12:31 PM narendba 480

sql-server-2005 tables data-size

0

votes

3

answers

532

views

SQL query help :)

May 31 '12 at 06:01 PM JohnM 4.5k

joins group-by tables sum

0

votes

3

answers

7.4k

views

SQL Server 2008 r2 table sizes

May 01 '12 at 08:10 AM Fatherjack ♦♦ 38.8k

tables

1

votes

3

answers

780

views

Strategy for refreshing a reporting table

Jan 29 '12 at 09:24 PM dataminor 200

reporting tables rename synonyms into

0

votes

3

answers

819

views

Alter table switch

Jan 25 '12 at 07:26 AM Wang 11

partitioning tables

2

votes

3

answers

993

views

How to validate table entries against multiple tables

Oct 31 '11 at 02:11 AM Magnus Ahlkvist 13.7k

foreign-key tables constraint key

1

votes

1

answers

393

views

delete records from a table that has multiple FK in Multiple tables

Jul 10 '11 at 01:09 PM KenJ 12.4k

tables

1

votes

0

answers

880

views

Which is the Best way to load XML into Oracle XML DB

Mar 09 '11 at 01:15 AM user-237 (google) 1 11

plsql schema tables metadata

0

votes

1

answers

583

views

Using Variable Tablename within a function

Oct 04 '10 at 12:06 AM Håkan Winther 15k

tables variables

1

votes

2

answers

893

views

How to Maintain Family relations in table

Jun 27 '10 at 09:17 AM Fatherjack ♦♦ 38.8k

tables relationships

3

votes

4

answers

2.2k

views

Deleting the Duplicate rows in the table ?

Jan 29 '10 at 11:28 AM OracleApprender 763

oracle tables

2

votes

1

answers

435

views

What are mutating tables ?

Jan 28 '10 at 10:48 AM OracleApprender 763

oracle tables

2

votes

1

answers

1.1k

views

Give the two types of tables involved in producing a star schema ?

Jan 14 '10 at 11:27 AM OraLearner 1.3k

oracle schema tables

1

votes

1

answers

389

views

Global Temporary Tables

Dec 18 '09 at 02:48 AM KillerDBA 1.5k

sql ddl tables global temporary

1

votes

3

answers

879

views

What Do I Query to Get Space and TempSpace Information?

Dec 03 '09 at 02:51 PM KillerDBA 1.5k

administration storage tables tablespace

0

votes

1

answers

390

views

Create table limits

Nov 13 '09 at 12:01 PM tomc 32

table tables

1

votes

3

answers

841

views

Is there any way to speed up dropping a user when they have a large number of tables etc?

Oct 29 '09 at 09:11 AM Cee 153

tables drop users cascade speedup

24 questions

47answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags

sql-server-2005 × 1834
ssis × 749
sql × 599
oracle × 359
performance × 220
administration × 119
joins × 100
reporting × 90
table × 76
plsql × 50
partitioning × 46
group-by × 32
schema × 29
ddl × 28
foreign-key × 27
views × 26
storage × 24
tables × 24
constraint × 18
sum × 18
tablespace × 17
variables × 17
rename × 10
drop × 9
users × 9
metadata × 7
relationships × 7
synonyms × 5
key × 4
global × 3
into × 3
cascade × 2
temporary × 2
data-size × 1
speedup × 1

posts per page 15 30 50

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.