Optimizing Your Cube's Schema
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/dchurch/optimizingyourcubesschema.asp
2002-03-21
5 reads
Interviews
Application Security
Designing an appropriate application security is a challenge to say the least. I am looking for a source that explain how to design a system that achieve full control on both the GUI and database objects. The security system should enable assigning privileges to each user. Any help is most appreciated.
2002-03-18
BCP in fails on file larger than 32Mb
I am currently experiencing the following problem. Has anyone else had it? I have a table with several char and integer fields, and with a single text field. I use BCP to output the data in native format. Now when I attempt to load the data back in, if the source data file being referred […]
2002-03-07
114 reads
Clustered index with very little disc space
I have a problem, disk space on a server we have is 80G with SQL server on it original size of that db was 9GB. We bought a company and imported a table into that db on that server as CFO's wish...the table is 58 GB. Everyone's querying on that table and need to build […]
2002-03-01
4 reads
2002-02-28
4 reads
What rules of thumb you live by when programming?
I have found that many bits of wisedom exist when it comes to programming. Thus I have, in my many years, developed 3 rules of thumb I follow that still bite me everyday. 1) It can almost always be done better. 2) Placement is everything. 3) Also double check 1 and 2 Ex. 1) SELECT […]
2002-02-26
3 reads
RPC problem?
Hi, I setup a Pull merge Replication between 2SQL2K, after the setup, the snapshot is being created, but the merge agent never started, when I try to start the agent i got this error: SQL Server EM could not start the Merge Agent Error 1722:[SQL-DMO] service control error :The RPC Server is unavailable. the subscriber […]
2002-02-16
6 reads
Calculating for weekends
I'm hoping someone can give me a nudge in the right direction on this one - I can't even figure out where to start. Right now I have a query where I'm trying to figure out which records fall within a certain amount of days: ... and datediff(minute, btbin, importdate) >= 1440 and datediff(minute, btbin, […]
2002-02-13
2 reads
AWE and Non-AWE Summary - is this correct ?
I have created a summary below. Is this correct ? Case 1 : AWE and Multi-Instances - statically use memory - SQL Server can access/use 8GB of RAM for SQL Server. Case 2 : AWE and no Multi-Instances - dynamically use memory - SQL Server can access/use 8GB of RAM for SQL Server. Case 3 […]
2002-02-11
2 reads
2002-02-07
8 reads
Blogs
A New Word: Mottleheaded
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
Democratizing Core Contributions: A Guide to WordPress.org Badges
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
Microsoft Purview GA menu’s
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers