I've just purchased a new computer (mac OSX) and I want to continue developing using the same database I had on the old computer. I don't want it remotely done cause I dont want to keep the other computer on. I just want to copy the db and put it on this computer for development. I have a USB sti...
I know Shopify use only one database for all shops.
But how can they handle their database with such big data?
Is that a good idea to use one database for 50.000+ shops?
I have a macro that adds zeroes to every number in column a until there are 7 total digits in the number, it has worked fine up until today and I am getting an error in the line For1= i=1 To endrow = -1 and I cannot figure out what it means.
THe code is
Sub AddZeroes()
'Declarations
Dim i As I...
In December, we launched our 3rd annual Stack Overflow Annual User Survey to learn more about our site demographics and user trends throughout 2012. Compared to last year, we received an even larger sample size this year with almost 10,000 respondents!
Here are a few larger trends we’ve observed over the past three years:
You like us…you really like us!
Since 2009, site traffic to Stack Overflow has grown by a whopping 261.7%! As if this weren’t enough, we’re also now the 86th largest global site, according to Alexa. Our crazy goal of breaking into the top 50 is looking less crazy! …
create table T(ID int identity primary key)
insert into T default values
insert into T default values
go
select cast(ID as varchar(10)) as ID
from T
where ID = 1
The query above has a warning in the query plan.
<Warnings>
<PlanAffectingConvert ConvertIssue="Cardinality Estimate" E...
SELECT *
FROM sec
WHERE sec.cu IN (SELECT s.cu
FROM sec s WITH (nolock)
WHERE EXISTS (SELECT *
FROM hact h WITH ( nolock),
JOIN dport p WITH ( nolock) ON h.ic = p.ic
...
This is probably a silly question but if I want a job to run Sunday at midnight would I choose Sunday 12:00AM or Monday 12:00AM?
I have a complex app that solves problems of multilateral compensation , so i have up to 60 queries run - depending of the level of how deep the queries go for the level of 5 the query is like this :
SELECT k.idpred1,
k1.idpred1 AS k1idpred1,
k2.idpred1 AS k2idpred1,
k3.i...
Maintenance plans are stored in msdb.dbo.sysssispackages like any other SSIS packages that are stored to SQL Server. I have a handy post on SSIS Package Extract from MSDB that should cure what ails you.
Are you running VSS backups on the server (NTbackup, BE, etc.) for stuff other than the SQL data? According to this, the SQL differential backups can be invalidated if a backup software uses VSS for snapshots.
As far as I know, LS does not use VSS just like Nick said. According to this thread ...
I have a database that has a 33 gb transaction log. It is caused by the fact that the database is in full recovery mode has been used for over 5 years prior to the first backup. I want to truncate and shrink the log file with the following command
Backup log dbname with truncate_only
go
DBCC s...
Your person table is not normalized so in order to retrieve data you will have to join multiple times like you found or you can use a UNION ALL query to unpivot the data.
This type of query will be similar to this:
select *
from work w
inner join
(
select person1 p_name
from person
union ...
